Define candidate key, alternate key, composite key.
Answer Posted / tanaji
A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.
| Is This Answer Correct ? | 23 Yes | 19 No |
Post New Answer View All Answers
How to list all dsn entries on your local machine using odbc_data_source()?
What is temporary table in sql server? Why we use temp table?
what are the three command line utilities and what are their primary functions?
Is it possible to update the views? If yes, how, if not, why?
What is a unique key constraint?
What is meant by referential integrity?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Explain trigger and trigger types?
What is the largest component inside a field?
How to create view in stored procedure sql server?
Explain what are partitioned views and distributed partitioned views?
Explain the different index configurations a table can have?
What are the triggers in sql?
How to replace the Query Result 'Null Value' with a text ?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?