Question

Which statement(s) is/are true?
i. A table should have only one primary key
ii. Primary keys can be composite
iii. A table should have only one candidate key

Answer 1

Answer:

1. True
2. True
3. False

Explanation:

1. The primary key in the table is enables the user to store and retrieve the unique data from the database.
2. The primary key can be form with the help of the more than one column. So, in this condition the primary key can be composite.
3. The table should have the multiple candidate keys in the table according to the need of the user.

#SPJ3