Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116012 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / jeevan kurmi
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Name few of the dcl commands in sql?
What are the five major components of a dbms?
How to enter unicode character string literals in ms sql server?
Define msdb database?
What is clustered index
What is the downside of using udf?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
When we should use and scope of @@identity?
How many databases instances are there in sql server 2000?
What does indexation mean?
Explain for xml explicit mode?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is table constraint?
What is 5nf in normalization form?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
