Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 6970 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 |
What is the difference between Clustered and Non-Clustered Index?
What is the command used to get the version of sql server?
What are sql server functions?
Can primary key be a foreign key?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
can you any body tell me why are go for the rebuild the master database.what is the reason?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is tempdb database? : SQL Server Architecture
Are connections to sql server encrypted?
Define left outer join?
What is an entity-relationship diagram (erd)?
What are the differences between ms sql server & oracle?
-
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)
