Define candidate key, alternate key, composite key.
- 13 Answers
- 111467 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
What is a bit datatype?
Would you store your query in a ssrs report or a database server? State the reason why?
What are xml indexes?
How to recreate an existing index in ms sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Determine when an index is appropriate?
What is difference statement and preparedstatement?
What is a hint?
How to provide column names in insert statements in ms sql server?
How to add a new dsn with the odbc driver for sql server?
Write a program using SQL queries to find a unique entry in a table.
Give the query of getting last two records from the table in SQL SERVER?
Why are you getting errors when creating a new odbc dsn?
Explain the types of indexes.
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
