SQL Server Questions and Answers – System Databases

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “System Databases”.

1. Which of the following is not a system database?
a) Northwind
b) Master
c) Tempdb
d) All of the mentioned
View Answer

Answer: a
Explanation: Northwind is a sample database.

2. Point out the correct statement.
a) By default, tempdb auto grows as needed while SQL Server is running
b) By default, master auto grows as needed while SQL Server is running
c) By default, pubs auto grows as needed while SQL Server is running
d) By default, msdb auto grows as needed while SQL Server is running
View Answer

Answer: a
Explanation: Tempdb holds all temporary tables and temporary stored procedures.

3. Which of the following holds temporary data?
a) Northwind
b) Master
c) Tempdb
d) Msdb
View Answer

Answer: c
Explanation: Tempdb is a global resource; the temporary tables and stored procedures for all users connected to the system are stored there.
advertisement
advertisement

4. Which is the most important system database?
a) Northwind
b) Master
c) Tempdb
d) All of the mentioned
View Answer

Answer: b
Explanation: The master database records all of the system level information for a SQL Server system.

5. Point out the wrong statement related to master database.
a) They are used to provide details of an backup plans
b) Master records the information for SQL Server temporarily
c) Master records the initialization information for SQL Server
d) None of the mentioned
View Answer

Answer: b
Explanation: Master is the database that records the existence of all other databases.
Note: Join free Sanfoundry classes at Telegram or Youtube

6. Which database is used as template for all databases?
a) Northwind
b) Master
c) Tempdb
d) Model
View Answer

Answer: d
Explanation: When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database.

7. Which of the following database is used by SQL Server Agent?
a) Pubs
b) Msdb
c) Tempdb
d) Model
View Answer

Answer: b
Explanation: The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
advertisement

8. How many types of system databases are present in SQL Server 2008?
a) 3
b) 4
c) 5
d) 6
View Answer

Answer: b
Explanation: Microsoft SQL Server 2008 have four system databases.

9. Which of the following system database occupies more space and memory?
a) Master
b) Msdb
c) Tempdb
d) Model
View Answer

Answer: a
Explanation: The master database records all of the system level information for a SQL Server system.
advertisement

10. The _________ database stores basic configuration information for the server.
a) Master
b) Msdb
c) Tempdb
d) Model
View Answer

Answer: a
Explanation: Master database includes information about the file locations of the user databases, as well as logon accounts, server configuration settings, and a number of other items such as linked servers and startup stored procedures.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.