Answer / palanivel

primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.

Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.

Composite key:- A primary key that consistsof two or more
attributes is known as composite key

candidate key:- is a column in a table which has the
ability to become a primary key.

Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.

Answer / divya

candidate key: is a column in a table which has thhe ability
to become a primary key.

alternate key:any of the candidate key that is not part of
the primary key.

Answer / garima sinha

candidate keys are those key which can be treated as
primary key when required.

composite key is made up of more than on key and treated as
primary key.


Alternate key (or secondary key) is any candidate key which
is not selected to be the primary key.

Answer / vishal sharma

hi, to all. In a interview i asked a question that

"How to apply practically candidate key in SQL SERVER ?
like for primary key we apply PRIMERY KEY keyword how to apply in SQL-SEVER ?"

Plz help me to solve this question Plzzzzzzzz

Answer / zulfiqar ali

ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.

2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.

Answer / jaison

Candidate key: A candidate key of an entity set is a
superkey for which no proper subset is a superkey

Answer / vishnu

Combine all foreign key in a table is none as composite key

Answer / koteswararao bora

candidate key:the minimum set of attributes which uniquely
identifies the touples in a table .
primary key:any candidate key choosen by the developer is
called primary key.
composite key: a candidate key which have more than one
attribute is called composite key.
alternate key: a candidate key other than primary key
is called alternate key.

Answer / deependra kumar shukla

Candidate key:- A key 'X' is said to be candidate key if proper subset of 'X' is not a key where X is simple or composite key.

Alternate key:- A candidate key is said to be Alternate key if it is not defined as primary key.An Alternate key may accept null values.

Composite key:- A key is said to be composite key if it contain more than one atribute of the relation.

Answer / sanjay p sonar

Candidate key:-A candidate key is unique. We may say that
candidate key is another name of primary key. We can have
more than one candidate key. From which we have to choose
one as a primary key.

Alternate key:-The Candidate key other than primary key is
Alternate key. We can have more than one Alternate keys.

Composite key:- When we combine more than 1 column by key
then that key is called Composite key

Clustered Key:- When we combine more than 1 column to form
Primary key then it will become Cluster key.

agregator gives one to many records or many to one record

1 Answers   IBM,

What are the 18 schemas?

0 Answers  

What is database design and development?

0 Answers  

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

what is difference between primary key and unique key ?

2 Answers  

Write the difference between case version and decode version.

2 Answers  

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

How can I detect whether a given connection is blocked?

0 Answers  

Explain about the database management systems.

0 Answers  

How can you log an error to the server event log from a stored procedure?

0 Answers  

What is a database development?

0 Answers  

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 insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers