Define candidate key, alternate key, composite key.
Answer Posted / anvar shadath.a
Candidate key: If any unique data column(s)in table is
called candidate key. may be one or more unique data column
(s).We can select any one unique (candidate key column) as
a primary key.
Alternate key: If one table contains more then one
candidate keys, remining candidate keys column(s) which is
not selected as a primary key is called Alternate Key.
Composite key: One primary key Contains more then one
columns is called Composite key.
| Is This Answer Correct ? | 75 Yes | 15 No |
Post New Answer View All Answers
Define inner join in sql server joins?
How many databases can we create in a single server?
How to make remote connection in database?
Why do we use non clustered index?
Do you know what guidelines should be followed to help minimize deadlocks?
What is awe?
What is a partition function in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is 5nf in normalization form?
What is a view in sql?
what are isolation levels? : Sql server database administration
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Explain what is raid and what are different types of raid levels?
Explain transaction server explicit transaction?
What is an index in sql?