In DBMS, what is the role of a DBA? MCQ with Answer and Explanation

Question

Share Report Error

In DBMS, what is the role of a DBA?

A. Data Backup Assistant

B. Database Administrator who manages the database system

C. Dynamic Binary Analyzer

D. Database Application Builder

Answer: Option B

Solution (By JKSSB Mock Tests)

The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

What is the purpose of the SQL 'UNION' operator?

A. To combine the results of two or more SELECT statements, removing duplicates

B. To aggregate data

C. To join tables horizontally

D. To filter duplicates

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UNION concatenates the result sets of two or more queries, eliminating duplicate rows. UNION ALL keeps duplicates.

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

Question #2

What is a deadlock in a database?

A. A type of backup

B. A query error

C. A situation where two or more transactions are waiting indefinitely for each other to release locks

D. A system crash

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Deadlock occurs when each transaction holds a lock that the other needs, resulting in a circular .

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

Question #3

Which of the following is a DCL (Data Control Language) command?

A. COMMIT

B. SELECT

C. GRANT

D. CREATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
GRANT and REVOKE are DCL commands. COMMIT is TCL, SELECT is DML, CREATE is DDL.

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

Explore All Database Management System (DBMS) MCQs