IN WHICH OF THE FOLLOWING DIRECTORIES ARE THE DEFAULT INSTANCE DAT...

12. In which of the following directories are the default instance database data and

log files located?

A. <drive>:\Program Files\Microsoft SQL Server\\100\Setup Bootstrap\

LOG\Files\

B. <drive>:\Program Files\Microsoft SQL Server\MSSQL10.

MSSQLSERVER\Data

C. <drive>:\Program Files\Microsoft SQL Server\MSSQL9.DEFAULT\Data

D. <drive>:\Program Files\Microsoft SQL Server\MSAS10.

E. <drive>:\Program Files\Microsoft SQL Server\MSRS10.

Correct Answer & Explanation: B. SQL Server 2008’s default directory is

under the Program Files\Microsoft SQL Server. The name of the database

directory is prefaced with the SQL Server Version ID of MSSQL10, plus a

period and the name of the database. The default database name is always

MSSQLSERVER.