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
- 7805 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 built in functions are there in sql server 2012?
Is foreign key unique?
What is the difference between the application object and session object?
What are the options which must be set to allow the usage of optimistic models?
Introduction of rollup clause using sum and group by clause?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
Can another user execute your local temporary stored procedures?
what is the difference between procedure and function.
what kind of lan types do you know? : Sql server database administration
Define inner join in sql server joins?
Explain cdc and sql injection?
What are the five characteristics of good data?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
