Answer / 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

Answer / pinak

the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is a temprary database.

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

How to tune a stored procedure?

6 Answers  

---

Define constraints and give an example of their use?

0 Answers  

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

what is memory-optimized nonclustered indexes

0 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

What is database architecture? : SQL Server Architecture

0 Answers  

---

What is trace flag in sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---