Define candidate key, alternate key, composite key.

Question Posted / swapna

13 Answers
111639 Views
Infosys, Software India, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Define candidate key, alternate key, composite key...

Answer / unknown

If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.

Is This Answer Correct ?

18 Yes

28 No

Define candidate key, alternate key, composite key...

Answer / mustafa

How do we specify an ALTERNATE KEY while creating a table?

Is This Answer Correct ?

15 Yes

30 No

Define candidate key, alternate key, composite key...

Answer / jheelum

A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY

Is This Answer Correct ?

26 Yes

82 No

Post New Answer