What is dirty page?

1037

---

What is extent? Types of extents?

1280

---

What is the default value of an integer data type in sql server 2005?

1000

---

What are the different editions available in sql server 2000?

1117

---

Can a synonym name of a table be used instead of a table name in a select statement?

1095

---

How do I determine how many instances of sql server are installed on a computer?

1059

---

What does the on update no action do?

1079

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1078

---

What is the parse query button used for?

1090

---

What stored by the model?

1141

---

When is the use of update_statistics command?

1060

---

Does an index slow down updates on indexed columns?

1039

---

What command would you use to add a column to a table in sql server?

1360

---

What is sql server 2000 work load governor?

1162

---

Are semicolons required at the end of sql statements in sql server 2005?

1038

---