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
What is extended stored procedures?
What is the difference between implicit and explicit transaction?
Can we install sql server 2016 on windows 7?
Explain the use of containers in ssis and also their types?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is a system database and what is a user database?
How do I find the port number for sql server?
What is not null constraint?
define and explain the differences between clustered and non-clustered indexes.
Do you know data definition language, data control language and data manipulation language?
What is the log shipping?
Can a table have 2 foreign keys?
What is measure group, measure? : sql server analysis services, ssas
Explain the truncate command?
What is buffer cash in sql server?