Database Management System - DBMS MCQ Questions and Answers Quiz

11. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

  1. Backup
  2. Concurrency
  3. Deadlock
  4. Recovery

12. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

  1. Backup
  2. Concurrency
  3. Deadlock
  4. Recovery

13. Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

  1. Backup
  2. Concurrency
  3. Deadlock
  4. Recovery

14. This is not a date type in SQL Server 2000

  1. Bigint
  2. Char
  3. String
  4. Decimal

15. A DBMS uses a transaction ……………… to keep track of all transactions that update the database

  1. block
  2. log
  3. table
  4. Statement

16. ……………… states that primary keys should not be null:

  1. Both
  2. Entity integrity
  3. Referential integrity
  4. None

17. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

  1. Both
  2. Back end
  3. Front end
  4. None

18. In which the database can be restored up to the last consistent state after the system failure:

  1. Both
  2. Backup
  3. Recovery
  4. None

19. The related and interconnected software components of a DBMS are described by the………………

  1. Both
  2. Logical architecture
  3. Physical architecture
  4. None

20. Which are the types of data independence:

  1. Both
  2. Physical
  3. Logical
  4. All of these
Tags

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

Database Management System - DBMS Question and Answer