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...


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

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 dml command?

0 Answers  


How to create a view on an existing table in ms sql server?

0 Answers  


What is the simplest way to create a new database in ms sql server?

0 Answers  


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


What is the command used to check locks in microsoft sql server?

0 Answers  


What is an identity column in insert statements?

0 Answers  


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  


What is function of CUBE ?

0 Answers   HCL,


What is the size of transaction log file?

0 Answers  


What is the disadvantages of index?

3 Answers   TCS,


Can we drop user if user mapped to any logins

1 Answers  


9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  


Categories