1. [单选题]You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.
A. You cancel the SQL Server upgrade wizard.
B. You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
C. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
D. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
E. Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
F. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
2. [单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
A. What should you do?
B. Enable the torn page detection database option for each database.
C. Disable write caching on all disk controllers.
D. Ensure that write caching disk controllers have battery backups.
E. Create a database maintenance plan to check database integrity and make repairs each night.
