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.
Bạn đang xem 12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P142 PDF