Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 6739 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Explain for xml explicit mode?
What are subquery and its properties?
In which tcp/ip port does sql server run? Can it be changed?
How to create an inline table-valued function?
What are the recovery models in sql server 2000?
What is subquery? Explain the properties of a subquery?
what does the automatic recovery do? : Sql server administration
How cand Optimize SQL Server Stored Procedures
What are wait types?
What is a benefit of using an after insert trigger over using a before insert trigger?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
