Answer / manoj

Primary Key is a column which uniquely identifies all records in a table. For example EmployeeID column in an Employee table.

If you add another column to a PK, like (EmployeeID+FirstName) it still identifies identifies all rows uniquely, is known as Super Key.

For more interview Questions on SQL Server: http://sqlwithmanoj.wordpress.com/interview-questions/

Answer / tanmay dutta

Primary Key : Unique No. Not null.No duplicate.exam:Student_Id.
Super Key : Like (student_id + Student Name)

Answer / anil kumar dubey

A candidate key that uniquely identifies a row in a table is called primary key.
A superkey (composite key) is a combination of columns that uniquely identifies any row within a relational database management system (RDBMS) table.

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

what is an sql server?

1 Answers  

---

What does the update command do?

0 Answers  

---

What is a covered index?

0 Answers  

---