what is candidate key & primary key,different b/t the two?
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
Explain the use of assign statement in progress database?
What is meant by a database?
What are the benefits of database management system?
What is openedge abl in terms of taking the perspective of the developer?
What is data model in database?
What are indexes? What are b-trees?
How to disconnect the user connection?
Explain the syntax of named procedure?
What are five types of database models?
Enlist the various transaction phases.
Which free database is best?
Why is rdbms important?
What is dbms with example?
What are the lock types?
How to debug stored procedures?