Database Management System - DBMS MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....