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

Do you know what is openxml in sql server?

1115

---

How to send email from database?

1073

---

Is port 1433 secure?

1040

---

What is simple indexing method?

1083

---

What are character string data types in ms sql server?

1349

---

How to use subqueries with the exists operators in ms sql server?

1182

---

How can you start sql server in different modes?

1021

---

How do I setup a sql server database?

1129

---

Explain an automatic checkpoint

1018

---

What it means to be triggered?

1082

---

Difference between uniqe index and uniqe constraint?

1045

---

Which autogrowth database setting is good?

1096

---

What are the types of table?

1031

---

Explain full-text query in sql server?

1054

---

In which files does sql server actually store data?

953

---