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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
What is the basic functions for master, msdb, tempdb databases?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the basic functions for master, msdb, tempdb databases?
Answer
# 1
the basics function of master is "it stores all sytem level 
information in it, all databases which need for user 
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is  a temprary database.
 
Is This Answer Correct ?    1 Yes 1 No
Pinak
 
  Re: What is the basic functions for master, msdb, tempdb databases?
Answer
# 2
Master , MSDB and TempDB
these are the inbuild Database which r provided by SQL 
SERVER.
All have their own functinality & responsbility like.

1. Master : Master DB is responsible for Storing all 
information at system level.
2. MSDB : it is Microsoft DB, it creates a Copy of whole 
Database in it
3. TempDB : it stores all the log information of Server,
it will initilize automatically wheneve Server will start,
the max. size alloted fro TempDB is 10MB.

Thanks & Regards
Dharmendra k. Dixit
 
Is This Answer Correct ?    1 Yes 2 No
Dharmendra K. Dixit
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How do you load large data to the SQL server database?  2
Is it possible to create tables in stored procedures using a variable for the table name?  1
What are defaults? Is there a column to which a default can't be bound?  2
What is MSDE?  1
what is difference between primary key and Unique  1
Which institute is best for SQL Server 2005 Training?  4
How do we get current date in SQL Server 2000, Oracle, MS Access?  10
How to Execute an Operating System Command From Within SQL Server ?  2
How to write a script for upate the data in prod , i have 50000 row are there TCS2
How to Get the last identity value used  3
Explain the basic concepts of SQL server architecture?  2
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance  6
Explain sp_configure commands, set commands?  1
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?  1
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
How to find the date and time of last updated table? Teledata1
What's the purpose of Stored Procedure? Wipro3
What is BCP? When do we use it?  1
Difference Between varchar and nvarchar datatype? Satyam2
What is a view?  1
 
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