what is candidate key & primary key,different b/t the two?
- 3 Answers
- 4587 Views
- I also Faced
- E-Mail Answers
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
Enlist the various transaction phases.
What is acid property in dbms?
How many records can a database hold?
Explain 3nf?
What do you mean by fill factor concept with respect to indexes?
Explain about the properties of cursors?
How can you perform pattern matching in sql?
Tell me about view, sequence and index in DBMS.
Compare a hierarchical and network database model?
why an information gap exists in most organizations.
What are the parts of a table?
What do you know about DBMS?
I want to export the data date to date from oracle database then what can i do?
Who invented schema theory?
What are the types of database users?
