Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 6090 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 the importance of a database?
What do you mean by conflict serializability in dbms?
Can group by and ordered by used in a single query?
Explain the difference between physical and logical data independence?
How is rdbms different from dbms?
Is google scholar a database?
How do you performance tune a database?
What is index and also explain types of indexing in dbms?
What are five main functions of a database administrator?
What do you mean by checkpoints in dbms?
How can we tune a oracle database if log file sync issue comes
What is the definition of database management system?
What do you mean by fill factor concept with respect to indexes?
What is a data type in a database?
What are the different levels of abstraction in the dbms?
