首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform full database b
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform full database b
admin
2009-05-19
80
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform full database backups every two days. You also run regular database consistency checks on the server. The most recent check of the Sales database returns the following message.
“CHECKDB found 0 allocation errors and 9 consistency errors in the table ’Orders’ (object ID 214575782).”
You want to correct the data integrity errors while minimizing the amount of data lost. What should you do?
选项
A、Disconnect users from the Sales database.
Enable the single user database option.
Execute the DBCC CHECKTABLE statement for the Orders table, and specify the
REPAIR_REBUILD option.
B、Disconnect users from the Sales database.
Enable the DBO use only database option.
Execute the DBCC CHECKTABLE statement for the Orders table, and specify the
REPAIR_REBUILD option.
C、Disconnect users from the Sales database.
Execute the RESTORE DATABASE statement for the Sales database
D、Execute the DBCC CLEANTABLE statement for the Orders table.
E、Execute the sp_table_validation stored procedure for the Orders table.
答案
A
解析
Explanation: We should repair the database with the DBCC CHECKTABLE REPAIR_REBUILD command. We should run this repair statement when the database is configured to single user.
Note: DBCC CHECKTABLE checks the integrity of the data, index, text, ntext, and image pages for the specified table or indexed view. DBCC CHECKTABLE can take a specified repair option to repair the found errors but must be in single-user mode to use a repair option.
It can specify the REBUILD_FAST option, which performs minor, non time-consuming repair actions such as repairing extra keys in nonclustered indexes and can be done quickly and without risk of data loss; and it can also specify the REPAIR_REBUILD option, which performs all repairs that can done by REPAIR_FAST and as well as time-consuming repairs such as index rebuilding. These repairs can also be done without risk of data loss.
Incorrect Answers:
B: The database option DBO use only, would only allow the database owner running the database. This might be too restrictive.
C: We are not told when how often consistency checks are performed but assuming that consistency occurs more frequently than the database backups then using RESTORE DATABASE to restore a database from the last full backup would result in the loss of data entered into the database since the last full database backup was performed. This would result in data loss.
D: DBCC CLEANTABLE is used to reclaim space after a variable length column or a text column is dropped using the ALTER TABLE DROP COLUMN statement.
E: The sp_table_validation stored procedure returns rowcount or checksum information on a table or indexed view, or compares the provided rowcount or checksum information with the specified table or indexed view. This stored procedure is used in replication and checks that the structure of the table being replicated between two tables are identical, i.e., that the tables have the same columns existing in the same order, same data types and lengths, and same NULL/NOT NULL conditions.
转载请注明原文地址:https://kaotiyun.com/show/wuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
关格之脾肾阳虚,湿浊内蕴证的治法为
主动脉血流能在心动周期中保持相对稳定,其主要原因是主动脉的
甲非法种植罂粟400株经公安机关行政处罚并强制铲除后,又私自到深山中种植罂粟300株,收获后制成鸦片出售一部分,自己留有250克供吸食之用,甲的行为构成________。
甲公司是一家建设投资公司,业务涵盖市政工程绿化、旅游景点开发等领域。近年来,夏日纳凉休闲项目受到青睐,甲公司计划在位于市郊的A公园开发W峡谷漂流项目(简称“W项目”),目前正在进行项目评价,有关资料如下:(1)甲公司与A公园进行洽谈并初步约定,甲公司一次
《中共中央国务院关于深化体制机制改革加快实施创新驱动发展战略的若干意见》强调,要鼓励各类企业通过股权、期权、分红等激励方式,调动科研人员的创新积极性。实施股权激励方式()。
目前世界上最大型、种类最丰富的一部巨著是:
将【E:\Tools】文件夹设置为共享文件,且允许网络用户更改文件。
有如下程序:#include#includeusingnamespacestd;classMyBag{public:MyBag(stringb
RockmusicwasA(original)B(amixture)ofcountrymusicandC(rhythm)D(and)blues.
Topuniversitieshavebeencalledontopublishlistsof"banned"A-levelsubjectsthatmayhavepreventedthousandsofstatesc
最新回复
(
0
)