Answer Posted / dharmendra k. dixit

Master , MSDB and TempDB
these are the inbuild Database which r provided by SQL
SERVER.
All have their own functinality & responsbility like.

1. Master : Master DB is responsible for Storing all
information at system level.
2. MSDB : it is Microsoft DB, it creates a Copy of whole
Database in it
3. TempDB : it stores all the log information of Server,
it will initilize automatically wheneve Server will start,
the max. size alloted fro TempDB is 10MB.

Thanks & Regards
Dharmendra k. Dixit

Can you name some of the dml commands in sql?

1074

---

What are the disadvantages of using querystrings to send data from one page to another?

1068

---

How do I create an extended event in sql server?

999

---

What is a unique key constraint?

1083

---

List the different normalization forms?

1018

---

Do you know what guidelines should be followed to help minimize deadlocks?

1013

---

Can group by and orderby be used together?

1063

---

how to trace the traffic hitting a sql server? : Sql server database administration

1942

---

Explain the architecture of ms sql reporting service?

968

---

What is difference between clustered index and non clustered index?

1115

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1133

---

What are the different types of stored procedures?

1155

---

Do you know sql server 2008 backup compression?

999

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

999

---

What are the difference between primary keys and foreign keys?

1010

---