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

Question

Options

• ARoot
• BMaster
• CLog
• DModel
• EView
• FIndex

• A
  3% (1)
• B
  91% (30)
• C
  6% (2)

Explanation

Master and Model are two of the five system databases automatically created during every SQL Server installation (the full set is master, model, msdb, tempdb, and resource). Master stores all server-level configuration, login accounts, and metadata about every other database - it is the most critical system database. Model serves as the template for all new user databases; any objects or settings placed in model are inherited by newly created databases.

The distractors are all red herrings: Root, Log, View, and Index are not SQL Server database names at all - "log" and "index" are components of databases (transaction log files, index structures), while "root" and "view" are concepts from other domains (Unix filesystems, SQL query objects) that have no corresponding default SQL Server database.

Memory tip: Think of the five system databases by the acronym MMRTT - Master, Model, Resource, TempDB, MSDB. On the exam, if a choice sounds like a file type or query keyword (log, index, view), it's almost certainly a distractor.

No community discussion yet for this question.