1. [单选题]You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.
A. CREATE PROCEDURE GetCustomer
B. ( @CustomerID Int )
C. AS
D. SELECT FirstName, LastName, Address1, Address2, City,
E. State, Zip, MAX(PurchaseDate) AS LastPurchase
F. FROM Customers C
G. AddressID = C．AddressID
H. CustomerID
I. CustomerID = @CustomerID
J. GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip
K. You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do?
L. Recompile the stored procedure.
M. Update the database statistics.
N. Check the consistency of the database and repair errors.
O. Create a view and modify the stored procedure to use the view.
2. [单选题]You need to install Windows 2000 Professional on 300 computers for a customer company called Ezonexam. The computers have different manufacturers and different hardware abstraction layers (HALs). You plan to use a Windows 2000 Server computer running Remote Installation Services (RIS) to perform. the installation.After the installation is complete for the first 25 computers, users of those computers report problems. You discover that the latest Windows 2000 service pack resolves those problems.
A. You want to apply the service pack to the remaining 275 computers during the installation. What should you do?
B. Install the service pack on a reference Windows 2000 Professional computer, and then run the Riprep command on that computer. Use the resulting image for RIS.
C. Install the service pack on the RIS server, and then run the Riprep command on that server. Use the resulting image for RIS.
D. Copy the service pack to the CD-based image shared folder used by RIS.
E. Slipstream the service pack into a new i386 distribution shared folder, and then run the Risetup command to create a new CD-based image for the RIS server.
