Answer Posted / rajesh bhawsar

1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master

What purpose does the model database server?

1143

---

Explain various On-Delete options in a DB table. Which is the default option?

1528

---

Explain Normalization and DE normalization

1156

---

What does executeupdate return?

1028

---

Explain what role entity and relationship play in an ER diagram.

1107

---

What is difference between commit and rollback when used in transactions?

1011

---

What stored by the model?

1133

---

What is the purpose of object explorer and its features? : sql server management studio

1269

---

what are the new features introduced in sql server 2000? : Sql server database administration

971

---

When should you use an instead of trigger?

1017

---

Explain mixed authentication mode of sql server?

1113

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1045

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6940

---

What is the use of keyword with encryption.

1081

---

Can a table have 2 foreign keys?

949

---