Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the basic functions for master, msdb, tempdb databases?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the basic functions for master, msdb, tempdb databases?..

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

Is This Answer Correct ?    16 Yes 10 No

What is the basic functions for master, msdb, tempdb databases?..

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.

Is This Answer Correct ?    8 Yes 10 No

Post New Answer

More SQL Server Interview Questions

What is the command used to get the version of sql server?

1 Answers  

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

Explain filtered indexes?

0 Answers  

What is normalization process?

0 Answers  

What is user-defined scalar function?

0 Answers  

How to select an exiting database using mssql_select_db()?

0 Answers  

What does ss stand for sexually?

0 Answers  

What is Data model and how to prepare a data model.?

1 Answers   TCS,

What do you do in data exploration

0 Answers   EXL,

What is the use of stored procedure?

0 Answers  

How to test a dml trigger in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories