Answer / Nirbhay Raj Singh

A natural primary key in SQL Server is a column or combination of columns that already contains unique values and are used as the primary key, without adding any explicit constraint. For example: CREATE TABLE Customers ( CustomerID INT PRIMARY KEY,n CustomerName NVARCHAR(50),n ... ) In this case, 'CustomerID' is a natural primary key.

What is RAID? What are the different types of RAID configurations?

1 Answers   Flextronics,

---

Define self join?

1 Answers  

---

What is the difference between Triggers and Stored Procedure?

1 Answers   HCL,

---

diffrence between function and procedure

5 Answers   Wipro,

---

Will sql server 2005 allow you to reduce the size of a column?

1 Answers  

---

What are rows and columns?

1 Answers  

---

What is log in sql server?

1 Answers  

---

Explain full-text query in sql server?

1 Answers  

---

What are the advantages of policy management?

1 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1 Answers  

---

SQL Server Architecture ?

1 Answers   IBM, Sapient,

---