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

If you think there is any confusion in the given MCQs, you can comment below.

Follow us on WhatsApp

docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.

Leave a Comment

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

Scroll to Top