can you any body tell me the difference between candidate
key and primary key
Answer Posted / pooja
A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.
candidate key:All that fields which can be selected as
primary key are called candidate keys.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the steps to follow to configure SQL*Net?
What is the security principal at the server level that represents your session?
When would you prefer to have a minimum number of indexes?
Detail about the hardware which is supported by SQL server?
What is store procedure? How do they work?
What are the events recorded in a transaction log?
Explain what are the authentication modes in sql server?
State the difference between local and global temporary tables?
How to attach adventureworkslt physical files to the server?
what is a check constraint?
What is policy management?
Which are the third-party tools used in sql server and why would you use them?
Explain transaction server consistency?
How to rebuild all indexes on a single table?
Define clusters?