Define candidate key, alternate key, composite key.
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
What is ms sql server triggers?
What is the command dbcc checkdb used for?
How to make a column nullable?
How to find which stored procedure is currently running in sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to connect Azure federated root database and apply federation in entity framework?
How can change procedure in sql server?
What is the simplest way to create a new database in ms sql server?
Why is the need for data conversion transformations?
What is acid properties?
How to provide default values to function parameters?
Explain iaas, paas and saas?
Does partitioning ssd reduce performance?
Explain forward - only cursors?
What is the xml datatype?