Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 5921 Views
- I also Faced
- E-Mail Answers
Answer Posted / parijatha
there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Discuss some of the techniques that can be used to tune operational performance.
What are the examples of database management system?
What do you mean by Correlated subquery in database?
Where is the database stored?
What are the different stages in 'data warehousing'?
when All datafiles related to a Tablespace are removed ?
What is concept of dbms?
What are the advantages of rdbms?
What is third normal form?
How to drop all foreign keys in database?
What are the key constraints in dbms?
What do you understand by functional dependency?
What do you understand by the view and mention the steps to create, update and drop a view?
What is query in rdbms?
What is the rdbms concept in sql?
