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 do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What are temporal tables in sql server 2016?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

---

Why use stored procedures in sql server?

0 Answers  

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

Can we use where clause in union?

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

How does stuff differ from the replace function?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---