Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116497 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
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
What are filegroups in sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the differences between triggers and stored procedures?
what are acid properties? : Sql server database administration
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Explain Geography datatype in SQL Server
what protocol both networks use? : Sql server database administration
mention different types of relationships in the dbms?
What is index fragmentation in ms sql server?
How many instances per computer are there in sql server 2000?
how to use DTS package in 2000,2005,2008 in sql server
Explain what is the function of sql server agent windows service?
what data regions are and what are the different data regions?
How to use the inserted and deleted pseudo tables?
Explain features of analysis services?
