单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the b

第1题：

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

• A、heap table
• B、object table
• C、external table
• D、clustered table
• E、global temporary table
• F、index-organized table （IOT）

第2题：

In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

• A、REBUILD
• B、CASCADE
• C、TRUNCATE
• D、ROW MOVEMENT
• E、SHRINK SPACE COMPACT
• F、SHRINK SPACE CASCADE

第3题：

You want to enable users of a Web application to modify the Web application's UI and behavior. These modifications must be maintained at the user level so that when users return to the Web application, the changes are still in effect. You need to achieve this goal by using the minimum amount of custom code. What should you do?（）

• A、Persist control data by using view state.
• B、Use Web Part controls.
• C、Maintain a profile for each user.
• D、Enable session state on the Web application.

第4题：

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application uses data-bound controls. You discover that when the application is executed by users, one of the controls is not displayed properly. You need to view the property values assigned to the controls. What should you do?（）

• A、 Use IntelliTrace. 
• B、 Use PresentationTraceSource.
• C、 Run the application in debug mode with Visual Studio 2010. Use the Auto window while you step through the application code.
• D、 Run the application in debug mode with Visual Studio 2010. Use the WPF Visualizer while you step through the application code.

第5题：

You are responsible for migrating client computers from Windows 98 and Windows NT Workstation 4.0 to Windows 2000 Professional. You have installed Windows 2000 Professional and reinstalled the necessary application on 10 computers. You have returned these computers to their users. The users of these computers report that their word processing application will not start. What should you do?（）

• A、Set the permission on the application to Execute.
• B、Add the application to the Run key in the registry.
• C、Apply the Securews.inf security template on the users’ computers.
• D、Apply the compatws.inf security template on the users’ computers.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

• A、Database replay
• B、SQL Tuning Advisor
• C、SQL Access Advisor
• D、SQL Performance Analyzer
• E、Automatic Workload Repository compare reports

第14题：

In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）

• A、hash clusters
• B、index clusters
• C、partitioned tables
• D、index­organized table （IOT）

第15题：

You develop a Web application. Your application contains two settings in the Web.config file. You deploy your application to production. You need to modify the application settings in the production environment without manually editing the XML markup in the Web.config file. What should you do? （）

• A、Modify the application settings by using the Web Site Administration Tool.
• B、Modify the application settings by using the Visual Studio property page editor for the project.
• C、Modify the application settings by using the resource editor.
• D、Modify the application settings by using the Visual Studio start options editor.

第16题：

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application requires frequent updates. You want to use the ClickOnce technology to distribute the application to Internet users. You need to ensure that the application is automatically updated without requiring user intervention. You also need to ensure that the users execute the most recent version of the application. What should you do when you publish the application? （）

• A、 Use Install the application from a file share. Select the Application is available online and offline option.
• B、 Use Install the application from CD-ROM or a DVD-ROM. Select the Application will not check for updates option.
• C、 Use Install the application from a Web site. Select the Application is available online only option.
• D、 Use Install the application from a Web site. Select the Application is available online and offline option.

第17题：

You have a computer that runs Windows XP Professional. Multiple users share the computer. You log on to the computer by using the local administrator account and install a custom application. You need to add an application shortcut to the desktop of all new users who use the computer. The shortcut must appear on the desktop of new users only. What should you do?（）

• A、Copy the shortcut to %systemdrive%/documents and settings/default user/desktop/.
• B、Copy the shortcut to %systemdrive%/documents and settings/all users/desktop/.
• C、Copy the shortcut to your desktop. Modify the %comspec% system environment variable. 
• D、Copy the shortcut to the guest user’s desktop. Assign the Everyone group Read permission to the guest user profile.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：