Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115970 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 does null mean?
Which are the third-party tools used in sql server and why would you use them?
What samples and sample databases are provided by microsoft?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Why it is recommended to avoid referencing a floating point column in the where clause?
What are indexes in ms sql server?
What is format parameter in ssrs?
Please illustrate physical database architecture? : SQL Server Architecture
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
How to provide column names in insert statements in ms sql server?
How to list all tables in the database using odbc_tables()?
What does indexation mean?
Explain few of the new features of sql server 2008 management studio
What is factless fact table? : sql server analysis services, ssas
What do you mean by a dependent functionality in a build?
