Define candidate key, alternate key, composite key.
- 13 Answers
- 113566 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
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 to change the data type of an existing column with "alter table" statements in ms sql server?
List some of the rules that apply to creating and using a ‘view’
Mention the different types of triggers?
Explain filtered indexes?
Do you know what is a with(nolock)?
What is the default Port No on which SQL Server listens?
Can we use trigger new in before insert?
What is the difference between locking and multi-versioning?
What is subreport?
Why SQL Agent is used?
How to insert new line characters into strings?
What is database replication? What are the different types of replication you can set up in sql server?
what is the system function to get current user's user id? : Sql server database administration
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What are the features of Embedded SQL
