1. [单选题]You are the network administrator for Ezonexam.com.You create two shared printers on a Windows 2000 Server computer in Ezonexam.com Ezonexam. One printer is shared as Admin, and the other printer is shared as Executive. Both printers are connected to the same print device. You set the priority of the Admin printer to 90 and the priority of the Executive printer to 50.
A. You want all users at the Ezonexam network to be able to send print jobs to either printer. However, you do not want the Executive printer to appear in the browse list when employees other than executives and administrative assistants create a new printer connection on their client computers.
B. What should you do?
C. Change the priority of the Executive printer to 99. Change the priority of the Admin printer to 1.
D. Deny the Everyone group the Manage Printers permission.
E. Change the printer configuration to Not Shared.
F. Clear the List in the Directory check box in the printer configuration.
2. [单选题]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.
