Simple questions about system databases

1. Identify system databases from the following:
a. Resources
b. AdventureWorks
c. Master
d. RTSDev
e. Temp
f. Model
g. Msdb
h. HRMS

2. Which one of the following databases used by SQL Server Agent
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

3. Which database records all server specific configuration information including users, Remote servers, databases, logon accounts and end points.
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

4. Which one of the following databases is recreated every time the SQL Server Starts?
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

5. Which one of the following databases, if unavailable, the SQL server database engine will not be started.
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

6. Which one of the following databases contains the initialization information of the SQL Server?
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

7. Which one of the following databases that holds all temporary tables and SPs
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

8. Which one of the following databases contains the path(location) of all other databases?
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

9. Which one of the following databases act as a template or prototype for the new databases
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

10. If you want a particular database object contained in all new databases created, you need to add the object to a system database. Choose one.
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

11. Which one of the following databases automatically used by the server to resolve large or nested queries or to sorting the data
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

12. Which one of the following databases that supports activities including Task scheduling, Alerts, Exception handling etc.
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

13. Which one of the following databases is read only db and does not contain user data
a. Master
b. Temp
c. Model
d. MSDB
e. Resource

Show Answers:

1. a, c, e, f, g
2. d
3. a
4. b
5. a
6. a
7. b
8. a
9. c
10. c
11. b
12. d
13. e


Hide Answers (X).

Reference: SQL Server 2005 Books Online (System Databases)