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

Spreading Education Across the World

USA - United States of America  Canada  United Kingdom  South America  South Africa  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....