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

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

What is the default server name for sql server?

0 Answers  

What is blocking and how would you troubleshoot it?

2 Answers  

What is the new security features added in sql server 2016? : sql server security

0 Answers  

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

What is a Trace frag?Where can we use this?

1 Answers  

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

How to convert character strings into numeric values?

0 Answers  

What are the types of database recovery models?

0 Answers   HCL,

Why Do you want to work in this company?

4 Answers   HCL,

How to recreate an existing index in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories