In an RDBMS, which of the following statements regarding database keys is false?

2026

In an RDBMS, which of the following statements regarding database keys is false?

  1. A.

    A table can have multiple Candidate Keys.

  2. B.

    A table can have multiple Primary Keys.

  3. C.

    A table can have multiple Alternate Keys.

  4. D.

    A table can have multiple Foreign Keys.

Attempted by 601 students.

Show answer & explanation

Correct answer: B

In an RDBMS, a table can have only one Primary Key, which uniquely identifies each record.
However, it can have multiple Candidate Keys, Alternate Keys, and Foreign Keys.
So the statement “A table can have multiple Primary Keys” is false.

Explore the full course: Up Lt Grade Assistant Teacher 2025