Define candidate key, alternate key, composite key.
Answer Posted / swapna
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 ? | 348 Yes | 54 No |
Post New Answer View All Answers
How many triggers you can have on a table?
What are ddl (data definition language) statements for tables in ms sql server?
What triggers long term care?
What is an example of a primary key?
Is there any difference between primary key and unique with the not null condition?
What is the difference between getdate and sysdatetime?
How to create a testing table with test data in ms sql server?
How many types of subqueries are there in sql server?
what are user defined datatypes? : Sql server database administration
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Are connections to sql server encrypted?
what is isolation level at dead lock?
What is the process of normalising?
Explain the microsoft sql server delete command?
What happens if we shrink log file in sql server?