Which of the following database instances are initiated by default when a database administrator installs a SQL Server instance for the first time? (Choose two.)

The correct answer is A. Model B. Master. When SQL Server is installed fresh, it automatically creates four system databases: master, model, msdb, and tempdb - making both Master (B) and Model (A) correct. Master stores all system-level metadata (logins, linked servers, configuration), while Model serves as the template

Database Fundamentals

Question

Options

AModel
BMaster
CRoot
DLog
EView
FIndex

How the community answered

(36 responses)

A
92% (33)
D
6% (2)
E
3% (1)

Explanation

When SQL Server is installed fresh, it automatically creates four system databases: master, model, msdb, and tempdb - making both Master (B) and Model (A) correct. Master stores all system-level metadata (logins, linked servers, configuration), while Model serves as the template from which every new user database is created.

The distractors are wrong because they don't represent SQL Server database instances at all: Root (C) is a Unix filesystem concept with no SQL Server equivalent; Log (D) refers to transaction log files that accompany each database, not a standalone database; View (E) and Index (F) are objects within a database, not databases themselves.

Memory tip: Think "MM" - Master and Model are the two you must know. Master "masters" the server, Model is the "mold" for every new database.

Topics

#SQL Server system databases#Master database#Model database#SQL Server installation

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice