ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
When you first load SQL SERVER you will startup with what 
all databases?
 Question Submitted By :: Veeresh Kethari
I also faced this Question!!     Rank Answer Posted By  
 
  Re: When you first load SQL SERVER you will startup with what all databases?
Answer
# 1		 
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
Sonia
 
  Re: When you first load SQL SERVER you will startup with what all databases?
Answer
# 2		 
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 ?    3 Yes 0 No
Mobin Sathupally
 
 
 
  Re: When you first load SQL SERVER you will startup with what all databases?
Answer
# 3		 
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
Rajesh S. Chandan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the difference between login and a user? TCS7
Different Types of Functions ? Satyam2
what is hash table Teledata2
how can i view structure of table in sql server? tell me that query.  4
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
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback ) iGate2
How reterive duplicate value in SQL?  5
What is a Join in SQL Server?  2
how to replace double quotes by single quotes in sql server CAC2
What is the datatype returned by count(*) Asian-CERC18
What is a trigger?  6
What is the difference between UNION and UNIONALL? CTS2
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
internal language used in sql server 2000?  1
how many type of subquery?  2
How do you simulate a deadlock for testing purposes  1
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100 HCL6
Wht is SQL Injection Attack ?  1
What is difference beteen Migration and Upgrdation? Satyam4
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Yardi-Software4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com