The SQL Server default when creating a new database is to create ________ for each database.
A)one data file and one log file
B)one data file and two log files
C)two data files and one log file
D)There is no default-the database creator must specify how many data files and log files will be created.

Question

Quizplus · Accepted Answer

This is the default setting for SQL Server when creating a new database. However, it is possible to change this and create multiple data files and/or log files during the creation process or after the fact.

The SQL Server Default When Creating a New Database Is