1.

Differentiate between Primary key and Candidate key. 

Answer»

A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table where as A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key. 



Discussion

No Comment Found

Related InterviewSolutions