首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
112
问题
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]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
CompanyIsMoreImportantthanGiftsWriteanessayof160-200wordsbasedonthedrawing.Inyouressay,youshould1)
Whileyouwereawayfromhomeonbusinessafewdaysago,yourfatherfellintoacoma.YourneighborMarystoppedacarandbro
Youarethepresidentofacompany.WriteamemotoSallyCooper,theHRmanagerontheemployeestrainingoncomputerto,1
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
TheEzonexamnetworkTopologyisdisplayedintheexhibitbelow:AswitchhasbeenconfiguredforthreedifferentVLANs:VLAN
随机试题
外源性支气管哮喘,浆细胞产生使人体致敏的抗体是
甲方要求加快某大型公建工程进度,采用以下的方法中哪种是不合适的?[2004-45]
某工程基础施工巾出现了意外情况,导致工程量由原来的2800m3增加到3500m3,原定工期是40天,则承包商可以提出的工期索赔值是()天。
在会计核算中款项是指作为支付手段的货币资金,下列各项中属于款项的有( )。
票据是一种不可转让证券。 ( )
(2017年济南高新)有些课题主要包含高度有结构的知识和技能(如数学、物理、化学、计算、语法等),如果教学目标足要求学牛尽快地掌握这些知识和技能,则宜采用()
日前,中山大学让大一新生阅读《弟子规》并撰写读后感,成了沸沸扬扬的新闻。某种意义上,将《弟子规》列为人学必读的经典,折射出当今大学思想教育的无奈——现有的思想教育体系已显僵化、老化,大量学生上德育课是“挣分数、混成绩”,难以获得真实的生命触动。中山大学的举
ThebusinesspracticesofAmericawillhaveyouintheofficefromnineinthemorningtofiveintheevening,ifnotlonger.Mu
Bysayingthat"Nobodywantstothrowoutthebabywiththebathwater"(Line1,Paragraph3),theauthorimpliesthatWecanin
Asiftheyneededanymoreexcuse,newresearchsuggestsmenneedtheirsleepifthey’retolivealonglife.Women,ontheothe
最新回复
(
0
)