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

Question Report Error

In DBMS, what is the role of a DBA?

A. Database Application Builder

B. Data Backup Assistant

C. Database Administrator who manages the database system

D. Dynamic Binary Analyzer

Answer: Option C

Solution (By JKExamLibrary)

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

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

What is a database transaction?

A. A query that reads data

B. A backup copy of the database

C. A database schema

D. A logical unit of work that consists of one or more SQL statements

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
A transaction is a sequence of operations performed as a single logical unit, ensuring ACID properties.

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

Question #2 Report Error

In SQL, the WHERE clause is used in:

A. Only CREATE statements

B. Only SELECT statements

C. SELECT, UPDATE, DELETE statements

D. Only INSERT statements

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.

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

Question #3 Report Error

Which command is used to retrieve data from a database?

A. INSERT

B. UPDATE

C. SELECT

D. DELETE

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The SELECT statement is used in SQL to query and retrieve data from tables.

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

Explore All Database Management System (DBMS) MCQs