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.

How much does sql server 2016 cost?

0 Answers  

---

What is a partitioned view?

0 Answers  

---

What is faster join or union?

0 Answers  

---

How sql server enhances scalability of the database system?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

Explain cursor as data base object?

0 Answers  

---

What is exclusive locks?

0 Answers  

---

How do I find query history in sql server?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

How to list all user names in a database?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---