Interested to Buy Any Domain ? << Click Here >> for more details...
Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 7894 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Do you know what is similarity and difference between truncate and delete in sql?
Is BCNF better than 2NF & 3NF? Why?
How many types of objects are there?
How to invoke a trigger on demand?
What are locks in sql?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are the extra roles available in msdb? : sql server security
Do you know what are acid properties of transaction?
Explain the difference between primary keys and foreign keys?
How to find the second highest salary of an employee?
How to connect Azure federated root database and apply federation in entity framework?
How will you find out if there are expensive SQL statements running or not?
Why use triggers?
What is unique key constraint?
What are the steps to insert a table?
