Database Management System - DBMS MCQ Questions and Answers Quiz

161. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

  1. Domain Integrity Constraints
  2. Entity Integrity Constraints
  3. Referential Integrity Constraints
  4. Key Constraints

162. 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

163. ……………… 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

164. ……………… 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

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

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

166. ……………… joins are SQL server default

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

167. Which are the three levels of abstraction:

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

168. Row is synonymous with the term:

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

169. Table is synonymous with the term:

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

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

  1. Foreign key
  2. Primary key
  3. Candidate key
  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....