Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116019 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
Why we use trigger in sql server with example?
When is the use of update_statistics command?
Can we use having clause without group by?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How does Report Builder support Analysis Services cubes?
Name few of the dcl commands in sql?
What is ms sql server triggers?
What is triggers and stored procedures?
What is the most common type of join?
What are the different types of stored procedures?
How to populate a table in sql server?
How to sort query output in descending order in ms sql server?
What is a cube? : sql server analysis services, ssas
Can we call stored procedure in view in sql server?
what authentication modes does sql server support? : Sql server database administration
