Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer

From 526 to 540 of 1187

Q. Data are stored in________ as database:

a. Data files

b. Data dictionary

c. Database

d. Data administrator

  • a. Data files

Q. ACID properties of transactions are

a. Atomicity

b. Consistency

c. Isolation

d. Durability

  • d. Durability

Q. DA stands for:

a. Data administrator

b. Database active

c. Define application

d. All of these

  • a. Data administrator

Q. DBA stands for:

a. Database maintenance

b. Database administrator

c. Database backup

d. Database designer

  • b. Database administrator

Q. Transaction is an action used to perform some manipulation on data stored in the____:

a. Memory

b. Record

c. Database

d. All of these

  • c. Database

Q. The data in the database at a particular moment in time is called a ________________

a. Database state

b. Valid state

c. Initial state

d. Empty state

  • a. Database state

Q. Which is a DBMS keeps back-up copies of the database:

a. Backup

b. Recovery

c. Both

d. None

  • a. Backup

Q. How many levels of abstraction in DBMS:

a. 2

b. 3

c. 4

d. 5

Q. Which are the three levels of abstraction:

a. Physical

b. Logical

c. External

d. All of these

  • d. All of these

Q. How many types of data independence:

a. 1

b. 2

c. 3

d. 4

Q. Which are the types of data independence:

a. Physical

b. Logical

c. Both

d. All of these

  • c. Both

Q. Which is the transformation of requests and results between different levels of abstraction:

a. Evaluation

b. Mapping

c. Compiler

d. Precompiler

  • b. Mapping

Q. Which mapping exists between the conceptual and internal levels:

a. Conceptual

b. Internal

c. Both

d. None

  • c. Both
Subscribe Now

Get All Updates & News