B.ULK INSERT Ezonexam.dbo.employees
F.ROM ‘tk/africe/fubar512.txt’
WITH DATAFILETYPE = ‘char’,
F.IELD/TERMINATOR = ‘/t’,
ROWTERMINATOR = ‘/n,’
TABLOCK
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.
H.ow should you improve the performance of the query in the exhibit above?
A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.
B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.
C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.
D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.
E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.
F. The TABLOCK option should be removed.
G. The ROWTERMINATOR line should be removed.
[单选题]To determine whether or not the employee correctly understands the message, the project manager needs to(75).(75) A. reduce the filteringB. eliminate barriersC. obtain feedbackD. use more than one medium
[名词解释] 整体沸腾 bulk boiling
[名词解释] 英译中:In bulk
[单选题]A.lthough the bulk of industry resources and energies have focused on developing the fastest(71)or slickest(72)more and more mindshare is turning to the evolution of the computer interface. Advancements in the areas of input devices,(73)processing an
[名词解释] 英译中:Bulk container
[名词解释] 英译中:Bulk carrier
[试题]Whenafire____attheNationalExhibitioninLondon,atleasttenpricelesspaintingswerecompletelydestroyed.(A)brokeoff(C)brokedown(B)brokeout(D)brokeup
[单选题]E.xhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.When users run the query in the exhibit above the receive the foll
[单选题]Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()A . SELECT last_name, depart
[单选题]You are an administrator of the Ezonexam switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in the Ezonexam network.H.owever, you n