Database Management System - DBMS Quiz Question with Answer

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 :

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....