1. [单选题]You are the administrator of Ezonexam's network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit.You create a Windows 2000 installer package file for the service pack. You use the package file to successfully install the service pack to other computers in the domain. You assign the package file to the Development organizational unit. After the installation, you notice that the service pack was not installed on any of the 10 computers.
A. You want to ensure that the service pack is successfully installed on the computers in the Development organizational unit. What should you do?
B. Use Computer Management to start the Windows installer service on all the computers in the Development organizational unit
C. Use the local administrator account to log on to the computers in the Development organizational unit. Then redeploy the service pack to the computers in the Development organizational unit.
D. Run Windows Installer to repair the package file. Then redeploy the service pack to the computers in the Development organizational unit.
E. Add the user accounts from the Development organizational unit to a DACL. Grant the user accounts read permission to the service pack deployment directory.
2. [单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers
A. FROM ‘di\bulk\accts143_10141000.txt’
B. WITH DATAFILETYPE = ‘char’,
C. FIELD/TERMINATOR = ‘\t’,
D. ROWTERMINATOR = ‘\n,’
E. TABLOCK
F. You want to ensure that response times do not slow when new account information is added to the database. What should you do?
G. Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
H. Remove the TABLOCK option from the BULK INSERT statement.
I. Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
J. Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
