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

Which databases are part of SQL server default installation?
Explain the usage of each?

Question Posted / guest

Answers were Sorted based on User's Feedback



Which databases are part of SQL server default installation? Explain the usage of each?..

Answer / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Is This Answer Correct ?    6 Yes 1 No

Which databases are part of SQL server default installation? Explain the usage of each?..

Answer / hari

In 2005 .newly implemented Resource Db

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What are the OS services that the SQL Server installation adds?

3 Answers  

What is self contained sub query?

0 Answers  

What is sqlcmd?

0 Answers  

What are truncate options available in sql server? : sql server database administration

0 Answers  

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

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

0 Answers  

What happens if you add a new index to large table?

0 Answers  

What is a coalesce function?

0 Answers  

What is the sql case statement used for?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories