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

When you first load SQL SERVER you will startup with what
all databases?

Question Posted / veeresh kethari

Answers were Sorted based on User's Feedback



When you first load SQL SERVER you will startup with what all databases?..

Answer / mobin sathupally

When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.

Is This Answer Correct ?    8 Yes 0 No

When you first load SQL SERVER you will startup with what all databases?..

Answer / sonia

guess what you want to ask is that what are the databases
that come by default? 4 - Master, Model, msdb, tempdb.

Is This Answer Correct ?    1 Yes 0 No

When you first load SQL SERVER you will startup with what all databases?..

Answer / rajesh s. chandan

It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.

When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.

Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is optimization and its types?

0 Answers  

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

What are wait types?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

How do I find the default sql server instance?

0 Answers  

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

How can I create a report based on a query? : sql server management studio

0 Answers  

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

How to remove duplicate rows from table except one?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories