what is candidate key & primary key,different b/t the two?
- 3 Answers
- 4612 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
What is mean by dbms?
What is the main purpose of normalization?
What do you understand by sub-queries in sql?
What are the four objects in a database?
What is the purpose of normalization in dbms?
Is declare cursor executable?
What restrictions can you apply when you are creating views?
What are the database skills?
How many columns are in a database table?
What are the five important software components of a database management system?
Mention a query to calculate the even and odd records from a table
What is super key in dbms?
Explain the classification of Database Management System?
what do u mean by implementation?
What are the types of database lock?
