Answer 1

Candidate Key
Candidate keys are those keys which is candidate for primary key of a table. In simple words we can understand that such type of keys which full fill all the requirements of primary key which is not null and have unique records is a candidate for primary key. So thus type of key is known as candidate key. Every table must have at least one candidate key but at the same time can have several.

Alternate Key
If any table have more than one candidate key, then after choosing primary key from those candidate key, rest of candidate keys are known as an alternate key of  that table. Like here we can take a very simple example to understand the concept of alternate key. Suppose we have a table named Employee which has two columns EmpID and EmpMail, both have not null attributes and unique value. So both columns are treated as candidate key. Now we make EmpID as a primary key to that table then EmpMail is known as alternate key.

Answer 2

A candidate key are those keys which are unique means these are the candidate for primary key of table
while
An alternate key is a set of candidate key which are not primary keys in table.

Answer 3

Candidate Key -Candidate keys are those which is unique,i.e. using these keys we can uniquely get the values of that particular tupple of a table. In simply The key which are eligible for primary key are candidate Key.

Alternate Key -Alternate Keys are those which are eligible for primary key but not used as primary key.

Answer 4

A candidate key is a combination of elements which can uniquely be defined in a table while an alternate key is a set of candidate keys in a table which are not primary keys.

Answer 5

Do we get real certificates once we're done with the course?

Just asking💁

Answer 6

Candidate Key Is Candidate For Primary Key Position Meaning That They're Eligible To Be Primary Keys(Have Unique Values And No Null Values).

Alternate Keys Are Those Candidate Keys Which Were Not Selected As The Primary Key Meaning Those Fields Havd No Duplicate And Null Values Which Are Not Used As Primary Key Are Alternate Keys.

Answer 7

Those attributes which are unique and not null i.e. candidate for primary key are known as candidate keys . Among the candidate key, attributes other than primary key is known as alternate key.

Answer 8

Pls javascript tag explaination

Answer 9

Siyabonga Sibiya Yes, you get a certificate.

Answer 10

Suppose a table has 5 columns which can uniquely identify a tuple in a relation.....these 5 columns will be called as candidate keys.....
We can choose any one of those keys as our primary key.....
After choosing the primary key,the rest 4 candidate keys are called alternate keys because they also fulfil all the conditions necessary to be the primary key........

Answer 11

Candidate Key :-
Candidate keys are those keys which is candidate for primary key of a table. In simple words we can understand that such type of keys which full fill all the requirements of primary key which is not null and have unique records is a candidate for primary key. So thus type of key is known as candidate key.

Alternate key :-
Candidate key OTHER than Primary key is called as Alternate key.

Answer 12

The keys which can be choose as Piramary key are called candidate keys
And the keys which can be choose as piramery key but after selecting one remaining candidate keys are called alternate keys