KnowledgeBoat Logo

Computer Science

If a table which has one Primary key and two alternate keys. How many Candidate keys will this table have ?

  1. 1
  2. 2
  3. 3
  4. 4

Relational Database

4 Likes

Answer

3

Reason — In a table, the primary key uniquely identifies each record, and alternate keys also uniquely identify records but are not the primary key. In this case, with one primary key and two alternate keys, the table will have three candidate keys in total: one primary key and two alternate keys. Candidate keys are potential keys that can uniquely identify records in a table.

Answered By

2 Likes


Related Questions