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
How can you perform pattern matching in sql?
How many records can a database hold?
Explain a tp monitor?
Why are databases so important?
What is tuple in rdbms?
Is sql is a dbms?
What is data sparsity and how it effect on aggregation?
Mention the differences between trigger and stored procedures
what are the two integrity rules used in DBMS?
Is filemaker pro a relational database?
What are service-specific middleware?
Which parameters are optional in init.ora parameter file?
Define ddl and dml.
What does rdbms stand for?
Can you drop all the columns of a table ?