首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
107
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
CompanyIsMoreImportantthanGiftsWriteanessayof160-200wordsbasedonthedrawing.Inyouressay,youshould1)
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Twomonthsago,yougotajobasaconsultantforHumanResourceServiceCompany.Butnowyoufindthattheworkisnotwhatyou
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
运用语言如何做到准确?下列说法正确的是()。
铅釉陶是哪个朝代的首创的
既能助阳解表,又能温通胸阳的药物是
半机械化币装中,吊推法安装设备的特点包括()。
财产清查中,全面清查一般在()情况下进行。
下列关于股票型基金的系统性风险的论述,正确的是()。
根据首季度增长情况,本期医药出口的增长的亮点是:()2006年首季度中国医药工业的总产值同比增长20.7%,图中显示增速低于行业水平的是:()
上级人民法院与下级人民法院之间的关系是()
WhatdoIwant?It’sreallyavery【C1】______question:yetmanyofusarenotsure.【C2】______itdoesn’thavetobeallthatdif
BeseraKostavaisthemasterofceremoniesfortheconcert.
最新回复
(
0
)