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

What is an sql server agent?

995

---

What is coalesce and check constraint in sql server?

1042

---

Define right outer join in sql server joins?

980

---

Do you know what is sql injection?

936

---

What are 3 ways to get a count of the number of records in a table?

1017

---

What are the types of stored procedures in an sql server?

934

---

How to convert binary strings into integers in ms sql server?

962

---

What is the purpose of the master database?

1052

---

How to convert a table data in XML format in sql server?

2493

---

What is importing utility?

933

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1044

---

What is meant by indexing files?

985

---

What is compound operators?

975

---

How to use the inserted and deleted pseudo tables?

914

---

Can primary key be null?

880

---