Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116051 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
Define outer join?
What is difference between inner join and full join?
Explain following error properties?
What are the indexes in sql server?
What are the difference between primary key and unique key? : sql server database administration
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain what is the function of sql server agent windows service?
How does using a separate hard drive for several database objects improves performance right away?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
when you create a database how is it stored? : Sql server database administration
What is Dependency Injection and provide example?
What is blocking and how would you troubleshoot it? : sql server database administration
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
