Database Management System - DBMS MCQ Quiz - Multiple Choice Questions & Answers Page 2

11. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

1. Index
2. Column
3. Constraint
4. Trigger

12. ……………….contains information that defines valid values that are stored in a column or data type.

1. Index
2. View
3. Rule
4. Default

13. The data in the database at a particular moment in time is called a ………………

1. Initial state
2. Database state
3. Valid state
4. Empty state

14. ACID properties of transactions are

1. Isolation
2. Atomicity
3. Consistency
4. Durability

15. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

1. isolation
2. atomicity
3. consistency
4. Durability

16. An attribute is a(n):

1. key of a table
2. two dimensional table
3. row of a table
4. column of a table

17. Retrieval of data is done by using a………………

1. Linked list
2. Stack
3. Query
4. All of these

18. Which of the following is not a level of data abstraction?

1. Logical Level
2. Physical Level
3. Critical Level
4. View Level

19. In which ways two tables may be related:

1. Many-many
2. One-one
3. One-many
4. All of these

20. A data dictionary is a repository that manages ………………

1. Metadata
2. Database
3. Memory
4. All of these