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
What are the main differences between primary key and unique key?
What do you understand by join?
Which parameters are optional in init.ora parameter file?
What are service-specific middleware?
How rdbms is different from dbms?
What is normalization in database with example?
What is db driver?
What are the ways to controlling cursor behavior?
What are the functions of rdbms?
What is the most popular database?
What do you mean by entity type extension?
Which is the best database?
What is query in database?
What do you mean by e-r model?
When does checkpoint occur?