System data Base

Question 1

When installing and instance of the SQL server, which 4 data bases are created by default

Answer 1

Master, Model, MSdb, Tempdb

Question 2

Master data base records all

Answer 2

System level information for an instance

Question 3

Which system data base is used as a templet for all data bases

Answer 3

model

Question 4

Which system data base is used by the SQL Server service agent

Answer 4

Msdb

Question 5

Which system data base is used as a workspace and hold temporary objects and intermediate result sets

Answer 5

Tempdb

Question 6

A system data base that is installed by default and cannot be seen and is read only,

Answer 6

Resource Data base

Question 7

Two report server data bases are

Answer 7

1- Report server - store info on report schema, property, parameters

2- report server Trmpdb- help improve performance

Question 8

Which database is only present if you configure replication and it stores meta data, history data, and transactions

Answer 8

Distribution Database