What is the purpose of the model database?

1076

---

What is the sql server 2000 version number?

1165

---

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

1096

---

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

1181

---

What is difference between delete & truncate commands?

1149

---

What stored by the msdb?

1050

---

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

1130

---

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

1254

---

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

1127

---

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

1091

---

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

1057

---

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

1117

---

What are sparse columns?

1077

---

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

1040

---

What does the on delete cascade option do?

1073

---