This set of Advanced Database Management System Multiple Choice Questions and Answers (MCQs) focuses on “Database Keys”.

PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE

view hide answers

1. Which one of the following allows us to uniquely identify the entity in the entity set?

  • Domain
  • Tuple
  • Row
  • Key

2. A_______is a set of one or more attributes that, taken collectively; allow us to identify uniquely an entity in the entity set.

  • Primary key
  • Super Key
  • Candidate Key
  • Foreign Key

3. A Super keys for which no proper subset is a super key. Such a minimal Super keys are called _______

  • Primary key
  • Simple Key
  • Candidate Key
  • Foreign Key

4. We shall use the term ________ to denote a candidate key that is chosen by the database designer as the principal means of identifying entities within in an entity set.

  • Primary key
  • Super Key
  • Candidate Key
  • Foreign Key

5. The _______ should be chosen such that its attributes are never, or very rarely changed.

  • Primary key
  • Super Key
  • Candidate Key
  • Foreign Key

6. ________ is the columns of a table that points to the candidate key of another table.

  • Primary key
  • Super Key
  • Candidate Key
  • Foreign Key

7. The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.

  • Parent table, Child table
  • Child table, Parent table
  • Child table, Referenced table
  • Both B and C

8. The purpose of the foreign key is to identify a particular row of ___________.

  • Parent table and Child table
  • Referencing table
  • Referenced table
  • Both B and C

9. The foreign key is equal to the candidate key in some row of the primary table, or else has no value (the NULL value.). This rule is called a ______ between the two tables.

  • referencing integrity constraint
  • referenced integrity constraint
  • referential integrity constraint
  • referred integrity constraint

10. ______ should not contain NULL value in its Attribute value.

  • Primary key
  • Super Key
  • Candidate Key
  • Foreign Key
Share with : Share on Linkedin Share on Twitter Share on WhatsApp Share on Facebook