what is candidate key & primary key,different b/t the two?
Answer Posted / uday shankar dokku
candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is google a database?
What are the four objectives of the selection of a data type?
What is the purpose of normalisation?
What is meant by database server?
What are the two main functions of queries in databases?
What is data model example?
What is difference between database and spreadsheet?
Explain about the properties of cursors?
When should you consider denormalization?
What is a driver in programming?
Explain the role of metadata for the three-layer architecture.
All questions related to Control m monitoring tool
what are the acid properties in dbms?
Explain the scenarios or situations under which progress database creates new index entry for a record?
How to activate all indexes in firebird?