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 are the two types of database?
Explain a tp monitor?
What is index hunting and how does it help in improving query performance?
When does checkpoint occur in dbms?
How many number of columns can a RECORD GROUP have ?
Explain the terms database and dbms. Also, mention the different types of dbms.
What is bcnf?
What is the normal procedure followed by a java client to access the db?
How to recreate the index on a firebird table?
what are the different kinds of indexing?
Why does reading require write privileges on database file?
State three differences between Dbms and Rdbms?
What do you understand by data redundancy?
What is the benefit of database?
dear sir please provide what question will be asked in CWE in bank it officer