DS0-001 practice question 6 of 15

Which of the following database instances are created by default when SQL Server is installed? (Choose two.)

Full set: 80 questions
Answer options
A: Root
B: Master Correct answer
C: Log
D: Model Correct answer
E: View
F: Index
Correct Answer:
B. Master; D. Model
Explanation

When Microsoft SQL Server is installed, it creates several system databases that are essential for its operation. Among the options provided, master and model are two of these default system databases. The master database contains all the system-level information for the SQL Server instance, including metadata about all other databases, login accounts, and system configuration settings. The model database serves as the template for any new user-defined databases created on the instance; its contents are copied to form the new database's initial structure and objects.

Why Incorrect

A. Root: 'Root' is not a standard database in SQL Server. The term typically refers to a superuser account or the top-level directory in a file system.
C. Log: A transaction log is a critical component (a file) of every database that records all transactions, but it is not a standalone database instance itself.
E. View: A view is a database object that represents a stored query as a virtual table. It is not a complete database.
F. Index: An index is a database object associated with a table or view that improves query performance. It is not a database.

References

1. Microsoft Corporation. (2023). System Databases - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/system-databases. (This document explicitly lists and describes the system databases, including master and model.)

2. Microsoft Corporation. (2023). master Database - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database. (See the first paragraph: "The master database records all the system-level information for a SQL Server system.")

3. Microsoft Corporation. (2023). model Database - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/model-database. (See the first paragraph: "The model database is used as the template for all databases created on an instance of SQL Server.")

Scroll to Top