IndiaBIX

Computer Science - Database Systems - Discussion

Discussion Forum : Database Systems - Section 1 (Q.No. 43)
Database Systems
43.
A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
the pin code
the last name
a compound key consisting of the first name and the last name
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
2 comments Page 1 of 1.
Supriya pati said:   1 decade ago
I think first name and last name of two people can be same. Ideal option would be to filter using address or none of the above in this case.

Any explanation of choosing option c?
Zibran said:   5 years ago
The last name is same for all the rows, it cannot be a candidate key. However, address and first name is the candidate key compounding together they can form the primary key.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers