Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

---

What are the advantages of the mirroring?

0 Answers  

---

What is normalization process?

0 Answers  

---

What are the advantages of using stored procedures in sql server?

0 Answers  

---

What is an identity column in insert statements?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---