Define candidate key, alternate key, composite key.
Answer Posted / kishore
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more columns is
called composite key.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to copy the tables, schema and views from one sql server to another?
What is checkpoint process in the sql server?
What is the difference between a clustered index and a non-clustered index?
What is the temp table?
What is shared lock?
How to create a simple table to test triggers in ms sql server?
What is sql or structured query language?
What are Spatial data types in SQL Server 2008
Explain system rowset functions?
What new data source types were added in ssrs 2014?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Is INSTEAD OF trigger directly applicable to Table ?
Explain user defined views?
When do you think a developer should use sql server-based cursors?
What is extended stored procedures?