Define candidate key, alternate key, composite key.
Answer Posted / jeevan kurmi
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 | 0 No |
Post New Answer View All Answers
How to update values in a table with update statements in ms sql server?
Explain the difference between function and stored procedure?
What are SSL and TSL protocols?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is tablix?
How can you check the level of fragmentation on a table?
How to change the system date and time from SQL Plus Terminal ?
What the different topologies in which replication can be configured?
What is bulkcopy in sql?
Explain system views?
What is bit data type?
What is the difference between for trigger and after trigger?
What do you understand by mirroring and mention the advantages of the mirroring?
What are the different types of stored procedures?