what is candidate key & primary key,different b/t the two?
Answer Posted / naz
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. Each Candidate
Key can qualify as Primary Key.
A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is database management system(dbms)?
What is data modelling techniques?
What is dbms and types of dbms?
What is 3nf in dbms?
Is excel a database?
What are the advantages of database?
What is implicit cursor in dbms?
What do you understand by clause in sql?
What is the type of image in database?
What is 2-tier architecture?
Tell us about some Dot operator queries?
What are different types of joins in sql?
What is the difference between star flake and snow flake schema?
What is a checkpoint in dbms and when does it occur?
Define entity, entity type, and entity set.