DEVFYI - Developer Resource - FYI

What is the difference between candidate key, unique key and primary key

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

612. What is the difference between candidate key, unique key and primary key

Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)

(Continued on next question...)

Other Interview Questions