Exercises · Q8
Q.Multiple choice: An attribute or combination of attributes that uniquely identifies each tuple in a relation is called a ______.
(a) foreign key
(b) primary key
(c) domain
(d) data type
ChseodishaTextbookSubjectiveImportance★★★★★est
53% · 8/15 Questions
You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.
Start your 14-day free trial to unlock the full solution →The correct option is (b) primary key.
A primary key is defined as an attribute (or combination of attributes) whose value uniquely identifies each tuple in a relation; it must be unique and never blank.
Why the other options are wrong:
- (a) foreign key — a foreign key refers to the primary key of another relation to create a link; it does not uniquely identify tuples in its own relation.
- (c) domain — a domain is the set of permitted values for an attribute (for example, 0 to 100 for marks); it does not identify tuples. …
Unlock everything free for 14 days
- Full step-by-step solutions
- Concept-first explanations
- Methods, shortcuts & mistakes
- PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.