What is the role of a database administrator (DBA)? MCQ with Answer and Explanation

What is the role of a database administrator (DBA)?
A. To manage and maintain the database system
B. To design the user interface
C. To write queries
D. To develop applications
Answer: Option A
Solution (By JKSSB Mock Tests)
A DBA is responsible for the overall administration, maintenance, performance, security, and backup of the database system.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Schema
B. Relation Instance
C. Relation Domain
D. Relation Card

Correct Answer: Option A


Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Projection Anomaly
B. Insertion Anomaly
C. Deletion Anomaly
D. Selection Anomaly

Correct Answer: Option C


Explanation:
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is NOT an advantage of DBMS over traditional file systems?
A. Data redundancy control
B. Simpler implementation and lower cost
C. Data independence
D. Higher data security

Correct Answer: Option B


Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.

This question belongs to: Computer Database Management System (DBMS)