What is the purpose of the model database?

1015

---

What is the sql server 2000 version number?

1078

---

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

1039

---

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

1117

---

What is difference between delete & truncate commands?

1081

---

What stored by the msdb?

998

---

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

1073

---

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

1144

---

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

1072

---

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

1041

---

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

999

---

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

1051

---

What are sparse columns?

1013

---

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

981

---

What does the on delete cascade option do?

1017

---