Question

Sanchita is working for a nationalised bank and is in the process of creating a table to store the details of customers of the bank.
Find out, which of the following fields of table Bank can be selected as primary key, candidate key and alternate key? CBSE 2011
Account No, Customer Name, Date of Birth, PAN Number, Opening Balance

Answer 1

Explanation:

Primary key AccountNo Candidate key AccountNo and PAN Number Alternate key PAN Number

Answer 2

Answer:

primary key:account no.