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
How to select a random record from a table?
What is the meaning of flat file database?
How many rows can a database hold?
What is normalization and why it is used?
Explain openquery function and openrowset function?
Where is database used?
What is dba stand for?
What is data modelling techniques?
Can you have more than one cursor open at any one time in a program ?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
Give us a non-computer example of preemptive and non-preemptive scheduling?
Explain meant by 3-tier architecture?
Is database a data structure?
What is the best way to determine whether firebird server is running?
What are cursors and what are the situations you will use them?