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
Explain the main control blocks available in ims db?
Enlist some commands of dcl?
Differentiate nested loop, hash join and merge join.
What is bcnf standard form in dbms?
Briefly describe the three types of sql commands.
How to do replication of firebird databases?
What do you mean by buffer manager?
What is database management used for?
Why c++ used in clipper?
What does partition mean in database?
How is data stored in a database?
Write a query to remove duplicate rows from a table?
Describe and contrast sql and qbe.
Explain about the properties of cursors?
What is tuple in rdbms?