MENU
Question -

Differentiate between the Primary key and Alternate key of a table with the help of an example.



Answer -

Primary Key – A primary key is a value that can be used to identify a unique row in a table .
Alternate Key – An alternate key is any candidate key which is not selected to be the primary key.
Example:
 
So, (Bank Account Number, Aadhaar Number) is a candidate key for the table.
Aadhaar Number ” Primary key
Bank Account Number ” Alternate Key

Comment(S)

Show all Coment

Leave a Comment

Free - Previous Years Question Papers
Any questions? Ask us!
×