Database Management System - DBMS MCQ Questions and Answers Quiz

71. To delete a database .................. command is used

  1. drop database database_name
  2. delete database database_name
  3. Delete database_name
  4. drop database_name

72. ……………… ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.

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

73. ……………… means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is complete

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

74. The ……………… statement is used to end a successful transaction.

  1. END
  2. COMMIT
  3. DONE
  4. QUIT

75. ……………… joins are SQL server default

  1. Equi
  2. Outer
  3. Inner
  4. None of the above

76. Which are the three levels of abstraction:

  1. External
  2. Physical
  3. Logical
  4. All of these

77. Row is synonymous with the term:

  1. Field
  2. Record
  3. Column
  4. Relation

78. Table is synonymous with the term:

  1. Field
  2. Record
  3. Column
  4. Relation

79. How many types of keys in relation database design:

  1. Foreign key
  2. Primary key
  3. Candidate key
  4. All of these

80. The candidate key is that you choose to identify each row uniquely is called ……………..

  1. Foreign Key
  2. Alternate Key
  3. Primary Key
  4. None of the above
Tags

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

Database Management System - DBMS Question and Answer