can you any body tell me the difference between candidate
key and primary key
Answer Posted / arijit
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How does recursive cte works in sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the different index configurations a table can have?
How to connect to SQL Azure Database by using sqlcmd?
Which sql server is best?
Why are sql functions used?
Where views are stored in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What programming language would you use to create embedded functions in ssrs?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is command parameter in ssrs?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Explain different types of Normalization.
What is the server name in sql server?
What is the benefit of normalization?