Multiple choice

Which of the following keys should be one or more than one in a table?

  1. Candidate key

  2. Super key

  3. Primary key

  4. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Candidate keys are special subsets of superkeys that do not have any extraneous information in them. Each table may have one or more candidate keys. A superkey is a combination of attributes that can be uniquely used to identify a database record. A table might have many superkeys. Hence, both the options 1 and 2 are correct.

Keep practicing — related questions