what is candidate key & primary key,different b/t the two?
Answers were Sorted based on User's Feedback
Answer / naz
A Candidate Key can be any column or a combination of
columns that can qualify as unique key in database. There
can be multiple Candidate Keys in one table. Each Candidate
Key can qualify as Primary Key.
A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / uday shankar dokku
candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is building blocks of client/server?
Define database lock and its types.
What are database modules?
What are the types of database management system?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
If I use netlib, will I find many other users to network with?
What is a functional dependency in the dbms?
What are the ways to controlling cursor behavior?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
what are the advantages of a client or server model ?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
What is procedure in dbms?