首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
Exhibit: BULK INSERT Ezonexam.dbo.employees FROM ‘tk\africe\fubar512.txt’ WITH DATAFILETYPE = ‘char’, FIELD/TERMINATOR = ‘\t’, R
Exhibit: BULK INSERT Ezonexam.dbo.employees FROM ‘tk\africe\fubar512.txt’ WITH DATAFILETYPE = ‘char’, FIELD/TERMINATOR = ‘\t’, R
admin
2009-05-19
30
问题
Exhibit:
BULK INSERT Ezonexam.dbo.employees
FROM ‘tk\africe\fubar512.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.
How 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.
选项
答案
F
解析
Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.
Incorrect Answers:
A, B, C, D: Effect would not be large
E: Some improvement, but not the best answer.
G: Would make the batch to stop working.
转载请注明原文地址:https://kaotiyun.com/show/6uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Supposeyouwanttoapplyforajobinacompanyasanofficesecretary.Writeanapplicationemailto1)introduceyourself
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Youaretheadministratorofyourcompany’snetwork.Thenetworkisconfiguredasshownintheexhibit.YouwanttoinstallWi
随机试题
属于功能位的颈椎摄影体位是
亚急性感染性心内膜炎的主要致病菌是
根据我国项目法人责任制的相关规定,下列表述中,正确的是( )。
注册会计师通过积累必要的审计证据认定会计报表整体不存在重大错报,对会计报表使用人提供一种保证。( )注册会计师对直接和严重影响会计报表的违反法规行为,应当在编制和实施审计计划时予以充分关注,以合理确信能发现此类违反法规行为。( )
审计机关组成审计组后,一般来说,应向被审计单位送达审计通知书的时间是()。
小明在记忆英语单词时,如果不对其加以复述,这个单词在他头脑中只能保持十几秒。这种记忆现象是()。
许勒位可现实()。
青少年如果连续看书时间过长,眼睛近视几乎是不可避免的。菁华中学的学生个个努力学习。尽管大家都懂得要保护眼睛,但大多数的学生每天看书时间超过10小时,这不可避免地导致连续看书时间过长。其余的学生每天看书也有8小时。班主任老师表扬的都是每天看书时间超过10小时
Elitememoryathletesarenotsodifferentfromtheirpeersinanyothersport:Theyfaceoffinintensecompetitionswherethey
•Readthetextbelowaboutconsumerelectronicsmodel.•Inmostofthelines34--45thereisoneextraword.Itiseithergram
最新回复
(
0
)