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 is normalization and what are the different types of normalization?
What is Database testing and What are ways of writing test cases for database testing?
How to open the database in exclusive mode?
What is database Configuration assistant ?
What do you mean by fill factor concept with respect to indexes?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What is database url?
What is the structure of a table in database?
What is database management system(dbms)?
Define and explain about progress?
How to retrive a single data from a database
What do you understand by cursor? Mention the different types of cursor?
What are the different types of modeling?
Why dbms is used?
Whats is an OLTP Database