Define candidate key, alternate key, composite key.
Answer Posted / raghuram
Candidate Key is a Key which identifies each row of a table
uniquely. Generally a Candidate Key becomes a Primary Key
of the table. If table has more than one Candidate Keys
then one is called Primary key and rest are called
Alternative Keys.
A key is formed by two or more columns is called Composite
Keys.
Is This Answer Correct ? | 80 Yes | 28 No |
Post New Answer View All Answers
Explain view in sql server?
What are the methods used to protect against sql injection attack?
How to disable a login name in ms sql server?
What are the approximate numeric data types?
Can I work with several databases simultaneously? : sql server management studio
What is difference statement and preparedstatement?
How do you troubleshoot errors in a SQL Server Agent Job?
What will be query used to get the list of triggers in a database?
What is 3nf normalization?
what is a self join? Explain it with an example? : Sql server database administration
Differentiate between a local and a global temporary table?
What is the native system stored procedure to execute a command against all databases?
What is nolock hint in sql server 2008
What is a result set object returned by mssql_query()?
Can we use where and having clause together?