Question 35
Database ManagementUse Table 1 to answer questions 35 and 36.
Columns 2 and 3 in Table 1 cannot be used as primary key because both fields contain
- A.the same datatype.
- B.only strings and numbers respectively.
- C.duplicate values.
- D.different datatypes.
Show the answer and explanation
Answer: C (duplicate values.)
Explanation
House has Yellow twice and Age has 15 twice, and a primary key must be unique.