Answer / shruti singh

Any attribute that is uniquely identify a row in a table is
candidate key for the table. We select one of the candidate
key as Primary key. All candidate keys which are not chosen
as "primary key" are Alternate keys. The key which uniquely
identify the rows of the table and which is made up of
more than one attribute is called Composite key.
As for Example:In a class we have to select Class Monitor.
So A, B,C and D stand for that post. So A,B,C and D are
candidate for monitor so these are candidate key. We select
B as monitor so B is primary key and A,C and D can be
monitor but not selected as a monitor so they are
alternative choise. So A,C and D are alternate key.
When two students of class work together in a project than
they are composite key for the class.

I TRIED TO EXPLAIN THESE KEY, IF YOU LIKE PLEASE DO
RESPONSE. iF YOU LIKE TO ASK ANY OTHRE QUE RELATED TO SQL
SERVER YOU CAN..

Answer / swapna

A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.

A key formed by combining at least two or more columns is
called composite key.

Answer / 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.

Answer / raghuram

Candidate Key is a Key which identifies each row of a table
uniquely. Generally a Candidate Key becomes a Primary Key
of the table. If table has more than one Candidate Keys
then one is called Primary key and rest are called
Alternative Keys.
A key is formed by two or more columns is called Composite
Keys.

Answer / amar

A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys. A key formed by
combining at least two or more columns is called composite
key.

Answer / sunil choudhary "hanumangarh"(

candidate key is a single key of each tuple.
alternative key is secondary key . for example(A entity
STUDENT an attribute of NAME,CLASS,ROLL.ID)the roll no is
primary key but id is alternate key.

A key formed combined of to or more columns called comosite
key.

Answer / tanaji

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.

Answer / sheharyar ali

Candidate Key
A coulmn in database table that can be used to uniquely identify each row in that table is said to be a Candidate Key
Primary Key
IF a Table has a coulmn or min Combination of Column(s) that can uniquley Identify each Row in that table then such a column or group of Column is said to be Primary Key

Alternate Key
A table may contain more than one Cadidate Column.Among these Candidate column the most appropiate one is genrally chosen as Primary Key While others that are left out are Said to be Alternate Keys.

Composite Key
Combination of more than One Column to uniquely identfiy all rows in a Table is said to be Composite Key

Answer / 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.

Answer / kishore

A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.

A key formed by combining at least two or more columns is
called composite key.

what is a correlated sub-query? : Sql server database administration

0 Answers  

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

How to create database with physical files specified in ms sql server?

0 Answers  

What are the differences between stored procedure and view in sql server?

0 Answers  

What stored by the model?

0 Answers  

Explain different types of Normalization.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

How to check parameter value in stored procedure sql server?

0 Answers  

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

What is compression - row-level and page-level compression?

0 Answers  

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

What is the library index called?

0 Answers