Administering Microsoft SQL Server 2012/2014 Databases — Question 8

Which of the following SQL Server 2012 database is NOT created by default in a new installation?

Answer options

• A. model
• B. msdb
• C. tempdb
• D. sql
• E. master

Correct answer: A

Explanation

The correct answer is A, as the 'model' database is not created by default in a new installation of SQL Server 2012. In contrast, the 'msdb', 'tempdb', and 'master' databases are all created automatically during the installation process, and 'sql' is not a default database in SQL Server.