DocMCQs Educational Banner

__ is a set of one or more attributes taken collectively to uniquely identify a record.

Question: __ is a set of one or more attributes taken collectively to uniquely identify a record.
  • A. a) Primary Key
  • B. b) Foreign key
  • C. c) Super key βœ“
  • D. d) Candidate key
Correct Answer: C. c) Super key
Explanation: A super key is actually a set of one or more attributes that uniquely identify a record.

Breakdown of the options:

Super key: Any set of attributes that uniquely identifies a tuple (row) in a relation (table).

Candidate key: A minimal super key (no unnecessary attributes).

Primary key: A chosen candidate key to uniquely identify a record.

Foreign key: A field in one table that refers to the primary key in another table.

So, while a super key is a broader term encompassing any set of attributes that uniquely identify a record, it's not the most specific or commonly used term. Candidate key or primary key would be more appropriate in most cases.

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top