what is candidate key & primary key,different b/t the two?
- 3 Answers
- 4889 Views
- I also Faced
- E-Mail Answers
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
Why is normalisation used?
What is dba in dbms?
What do database languages do?
How many types of rdbms are there?
Mention a query to add email validation to your database
Explain the importance of database partitioning.
Describe why operational and informational systems are separate.
Explain the three Level Architecture of the Database System
What does a database contain?
What is data model in database?
What are the types of database servers?
What do you mean by conflict serializability in dbms?
How to handle data if f table are more than one and each table contain thousands of entries?
What is data management process?
Can videos be stored in a database?
