If no candidate keys exist in a table,which of the following is used?
A)surrogate key
B)dummy key
C)primary key
D)index key

Question

Quizplus · Accepted Answer

If no candidate keys exist in a table, a surrogate key is used as the primary key. A surrogate key is a system-generated unique identifier that is added to the table explicitly to serve as the primary key. This surrogate key does not contain any business logic and has no meaning to the users.

If No Candidate Keys Exist in a Table,which of the Following