首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of
You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of
admin
2009-05-19
35
问题
You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of tables that track the location of parts. The tables are configured as shown in the Database Schema exhibit.
You examine the indexes in the PartsLocations table. The indexes are configured as shown in the Indexes exhibit.
You also examine the contiguity of the PK_partsLocations index and receive the following results:
DBCC SHOWCONTIG scanning ’PartsLocations’ table...
Table: ’PartsLocations’ (1); index ID: 1, database ID: 6
TABLE level scan performed.
- Pages Scanned................................: 3000
- Extents Scanned..............................: 750
- Extent Switches..............................: 502
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Logical Scan Fragmentation...................: 33.33%
- Extent Scan Fragmentation....................: 33.33%
- Avg. Bytes Free per Page.....................: 1166.0
- Avg. Page Density (full).....................: 85.77%
You need to improve the performance of the queries that join this table to the Parts table and the Locations table. What should you do?
选项
A、Re-create the PK_PartsLocations index as a clustered index.
B、Re-create the IX_PartsLocations_PartsID as a clustered index.
C、Re-create the IX_PartsLocations_LocationId as a clustered index.
D、Re-create the PK_PartsLocations index as a nonclustered index.
答案
A
解析
Explanation:The output of the DBCC SHOWCONTIG shows that the clustered index of the table is fragmented. Both Logical Scan Fragmentation and Extent Scan Fragmentation are above 10%. The clustered index PK_PartsLocations should be rebuilt.
Note: In general, you need to do very little in terms of index maintenance. However, indexes can become fragmented. You can use the DBCC SHOWCONTIG command to report on the fragmentation of an index.
You can use either the Extent Scan Fragmentation value or the Logical Scan Fragmentation value to determine the general level of fragmentation in a table. Logical Scan Fragmentation and, to a lesser extent, Extent Scan Fragmentation values give the best indication of a table’s fragmentation level. Both these values should be as close to zero as possible (although a value from 0% through 10% may be acceptable).
Incorrect Answers:
B, C: There already exists a clustered index, the PK_PartsLocations index. A table can only contain one clustered index.
D: A clustered index is faster that a non-clustered index. We should rebuild the clustered index, not create a nonclustered index instead.
转载请注明原文地址:https://kaotiyun.com/show/muhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Writeanessayof160-200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Whileyouenjoythesunlight,itcastsyourshadowontheground.Therehasbeenadiscussionrecentlyontheissueinanewspap
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
Bobisanewsecurityadministratoratafinancialinstitution.Theorganizationhasexperiencedsomesuspiciousactivityonone
随机试题
判断营养不良程度的重要指标之一是
铸造金属全冠颈部肩台宽度不小于
A省甲公司拟于2008年向欧盟出口钨粉80吨,2007年8月6日,甲公司向A省商务厅申请办理钨粉出口许可证,被告知钨产品出口配额由A省人民政府行政许可服务中心集中分配,甲公司于2007年8月13日向行政服务中心报送申请钨粉出口许可证材料。行政许可服务中心人
当事人一方依照法定解除的规定主张解除合同的,应通知对方合同自( )时解除。
施工占用慢行道和便道要获得()部门的批准。
一、注意事项1.本题本由给定资料与作答要求两部分构成。考试时限为150分钟。其中。阅读给定资料参考时限为40分钟,作答参考时限为110分钟。2.请在题本、答题卡指定位置上用黑色字迹的钢笔或签字笔填写自己的姓名和准考证号,并用2B铅笔在
在我国,中央国家机关的领导人都是由全国人民代表大会选举产生的。()
下列所列情形中,哪些构成生产、销售伪劣产品罪?()
Whichofthefollowingcountrieshasenjoyedthefastesteconomicgrowthinhistory?Whatisthemostimportantfactorthatlea
Vegetarianswouldprefernottobecompelledtoeatmeat.Yetthereversecompulsion(强迫)ishiddenintheproposalsforanewp
最新回复
(
0
)