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 the purpose of linked server configuration in sql server?

1055

---

Explain unique key in sql server?

1017

---

What is exporting and importing utility?

1095

---

In which sql server version report builder introduced?

150

---

How to set database to be single_user in ms sql server?

1041

---

What is sleeping status in sql server?

1030

---

Explain what is lock escalation and what is its purpose?

938

---

Can a function call a stored procedure in sql server?

966

---

How do you handle datasets larger than 50 gb?

162

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2095

---

What are relationships and mention different types of relationships in the dbms

966

---

what is the maximum size of a row? : Sql server database administration

1021

---

Explain about extended stored procedure?

950

---

Explain index in sql server?

1024

---

do views contain data ?

976

---