Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

How to execute a sql statement using mssql_query()?

0 Answers  


how can u get last observation in an unknown dataset ?

0 Answers   Genpact,


What is the boxing and unboxing concept in .net?

0 Answers  


What is the difference between Normalization and De-normalization?

0 Answers   TCS,


What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  






What is rtm version in sql server?

0 Answers  


What is the recovery model?

0 Answers  


What are the basic features of a trigger in ms sql server?

0 Answers  


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  


From where can you change the default port?

3 Answers  


How to disable a login name in ms sql server?

0 Answers  


what is a mixed extent? : Sql server administration

0 Answers  






Categories