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


Which databases are part of SQL server default installation?
Explain the usage of each?

Answers were Sorted based on User's Feedback



Which databases are part of SQL server default installation? Explain the usage of each?..

Answer / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Is This Answer Correct ?    6 Yes 1 No

Which databases are part of SQL server default installation? Explain the usage of each?..

Answer / hari

In 2005 .newly implemented Resource Db

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  


How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  


What is resultset concur_updatable?

0 Answers  


What are scalar functions?

0 Answers  


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,






Explain what are various ways to enhance the ssrs report?

0 Answers  


How is a full-text index updated?

0 Answers  


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


What stored procedure can you use to display the current processes?

0 Answers  


How to query multiple tables jointly?

0 Answers  


What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,


What are a scheduled jobs or what is a scheduled tasks?

0 Answers  






Categories