What is the purpose of the model database?

1071

---

What is the sql server 2000 version number?

1152

---

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

1091

---

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

1178

---

What is difference between delete & truncate commands?

1147

---

What stored by the msdb?

1049

---

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

1124

---

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

1245

---

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

1122

---

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

1091

---

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

1053

---

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

1111

---

What are sparse columns?

1070

---

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

1035

---

What does the on delete cascade option do?

1068

---