首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
37
问题
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
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
Writeanessayof160~200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
A肺活量B用力肺活量C每分通气量D肺总容量E肺泡通气量真正有效的通气量是
对深Ⅱ°烧伤的描述正确的是
宫颈癌湿热瘀毒证方剂首选
【2009年第59题,2012年第46题】热轧钢筋经冷拉后,能提高下列哪种物理力学性能?
某企业生产车间甲产品直接耗用原材料2000元,生产乙产品直接耗用原材料4000元,车间管理部门耗用原材料1000元,正确的会计分录是()。
审计工作底稿归档后,注册会计师如认为有必要修改或增加审计工作底稿,无论修改或增加的性质如何,均应记录的事项有()。
《文化新报》的记者小白周四去采访两位学者,陈教授和王研究员。次日其同事小李问小白:“昨天你采访到那两位学者了吗?”小白说:“不,没那么顺利。”小李说:“那么你一个都没采访到?”小白说:“也不是。”
(2015年真题)国家主席无须根据全国人大和全国人大常委会的决定独立行使的职权是()。
需求管理是一个对系统需求变更、了解和控制的过程,以下活动中,______不属于需求管理的主要活动。
顺序存储方法是把逻辑上相邻的结点存储在物理位置【】的存储单元中。
最新回复
(
0
)