Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116500 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / unknown
If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.
| Is This Answer Correct ? | 18 Yes | 28 No |
Post New Answer View All Answers
How to view existing indexes on an given table using sp_help?
What is explicit cursors?
What gets stored inside msdb database?
What is ddl and dml commands?
How to use clusters?
Explain throw statement in sql server 2008?
What is the difference between web edition and business edition?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Does sql server 2016 have ssms?
how you can list all the tables in a database?
Can we join two tables without primary key?
Where cross join is used?
Explain having clause?
Can a function call a stored procedure in sql server?
What is difference between delete & truncate commands?
