1.You create an ASP.NET application that produces sales reports. The sales data is stored in a Microsoft SQL Server database that is used for transaction processing. The application consists of complex Transact-SQL statements. Many users report that the report generation is taking longer to run each day. You need to improve response times. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.) A:Use an OleDbDataAdapter instead of a SqlDataAdapter to access the data.B:Ensure that appropriate indexes exist on the SQL Server tables.C:Rewrite your SQL statements to use aliases for all table names.D:Rewrite your direct SQL statements as stored procedures and call the stored procedures from your application.E:Configure queries to run in the security context of the user who is running the query.Correct Answers:  B, D 2.You are creating an ASP.NET application for an online bill payment service. The service allows users to pay their bills electronically by using a credit card. The application includes a payment page named Payment.aspx. This page contains a form for entering payee, payment amount, and credit card information. When a user needs to submit a new billing address to a payee, the page form allows the user to provide the new address information. If the user indicates a change of address, the application needs to provide the information to the ProcessAddressChange.aspx page for processing as soon as the user submits the payment page information. The ProcessAddressChange.aspx page processes the request for a change of address but does not provide any display information for the user. When the requested processing is complete, Payment.aspx displays status results to the user. You need to add a line of code to Payment.aspx to perform the functionality in ProcessAddressChange.aspx. Which line of code should you use? A: Response.Redirect("ProcessAddressChange.aspx");B: Response.WriteFile("ProcessAddressChange.aspx");C: Server.Transfer("ProcessAddressChange.aspx", true);D: Server.Execute("ProcessAddressChange.aspx");Correct Answers:  D 3.You are creating an ASP.NET application for Coho Vineyard & Winery. Your application will call an XML Web service run by Wide World Importers. The XML Web service will return an ADO.NET DataSet object containing a list of companies that purchase wine. You need to make the XML Web service available to your application. What should you do? A: On the .NET tab of the References dialog box, select System.Web.Services.dll.B: In the Web References dialog box, type the address of the XML Web service.C: Add a using statement to your Global.asax.cs file, and specify the address of the XML Web service.D: Write an event handler in the Global.asax.cs file to import the .wsdl and .disco files associated with the XML Web service.Correct Answers:  B 4.You are creating a new ASP.NET page named ItemList that displays item and price information for many different items. When a user logs on to the Web site, the page retrieves the current list of prices from a database. ItemList will be accessed by several thousand registered users. When a price list is retrieved for a user, the prices remain valid for as long as the user continues to access the page. Users are allowed to keep the same price list for several days. When ItemList is posted back to the server, you want to ensure that the price list was not altered on the user's computer. You also want to minimize the memory resources consumed on the Web server. Which three parameters should you add to the Page directive in ItemList? (Each correct answer presents part of the solution. Choose three.) A:EnableSessionState="True"B:EnableSessionState="False"C:EnableSessionState="ReadOnly"D:EnableViewState="True"E:EnableViewState="False"F:EnableViewStateMac="True"G:EnableViewStateMac="False"Correct Answers:  B, D, F 5.Your ASP.NET application displays sales data on a page. You want to improve performance by holding the page in memory on the server for one hour. You want to ensure that the page is flushed from memory after one hour, and that the page is re-created when the next request for the page is received. What should you do? A: Initialize a new instance of the Cache class in the Application.Start event handler.B: Initialize a new instance of the Timer class in the Page.Load event handler.C: Set the Duration attribute of the OutputCache directive in the page.D: In the Web.config file, set the timeout attribute of the sessionState element.Correct Answers:  C 6.You write code to perform standard financial calculations that are required by your company. The code accepts input parameters such as interest rate and investment amount. It then calculates values based on different predetermined scenarios. You want to create a control that encapsulates this functionality. You want to be able to easily use this control by dragging it from the toolbox onto your Web Forms. You also plan to include full support for visual design tools. You want to create a project to test the control. Which two courses of action should you take? (Each correct answer presents part of the solution. Choose two.) A:Create a Web user control.B:Create a Web custom control.C:Create a new Web Form project.Use the COM Components tab of the Customize Toolbox dialog box to specify the new control.D:Create a new Web Form project.Use the .NET Framework Components tab of the Customize Toolbox dialog box to specify the new control.E:Create a new Web Form project.Select Add Reference from the Project menu and browse to the new control.Correct Answers:  B, D 7.You are creating an ASP.NET page for your company. Employees at the company will use the page to enter suggested names for new products. Each suggestion is saved in a Microsoft SQL Server database. The table in the database for suggestions includes the following three columns. To add a suggestion to the ASP.NET page, an employee logs on by entering the appropriate EmployeeID and password. The employee then uses a drop-down list box to select a ProductID and uses a grid to enter suggested names for that product. The employee can enter multiple suggestions for a single product before submitting the page. The database table has a unique index that includes the EmployeeID, ProductID, and Suggestion columns. The unique index does not allow the same suggested name to be recorded twice for the same product by the same employee. You are using a SqlDataAdapter object to insert the suggestions into the database. If one of the suggested names for a product is a duplicate, the database returns an error to your code. You do not want such errors to interrupt processing. You want your code to continue inserting any remaining suggestions entered by the employee. You also want to be able to access a list of any suggested names that were skipped due to errors. What should you do?

本新闻共2页,当前在第1页  1  2