What is the purpose of the model database?

1032

---

What is the sql server 2000 version number?

1092

---

Name 3 ways to get an accurate count of the number of records in a table?

1049

---

What is the difference between a local and a global temporary table?

1136

---

What is difference between delete & truncate commands?

1097

---

What stored by the msdb?

1010

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1083

---

What command must you use to include the not null constraint after a table has already been created?

1166

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1086

---

What are the different types of replication are there in sql server 2000?

1048

---

What are system databases into sql server (2005/2008)?

1009

---

How many database files are there in sql server 2000?what are they?

1062

---

What are sparse columns?

1024

---

How can we rewrite sub-queries into simple select statements or with joins?

993

---

What does the on delete cascade option do?

1030

---