What are page splits?

1004

---

What are different types of statements that are supported by sql?

1050

---

Characterize join and name diverse sorts of joins?

974

---

Why would you use sql agent?

1274

---

What are the different types of backups avaialabe in sql server 2005?

1026

---

What is set nocount on?

946

---

What are the different types of upgrades that can be performed in sql server?

1180

---

What does null mean?

994

---

What is the difference between truncate and delete commands?

1077

---

What is normalization? What number of normalization shapes are there?

1116

---

What is collation?

1148

---

What are the operating modes in which database mirroring runs?

1097

---

Define self join?

1035

---

Does transparent data encryption provide encryption when transmitting data across the network?

1054

---

What are transactions and its controls?

1067

---