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.
第2题
A.EMPTY(.NULL.)
B.LIKE("edit"," edi?")
C.AT("a","123abc")
D.EMPTY(SPACE(10))
第8题
A.EMPTY(.NULL.)
B.LIKE("edit","edi?")
C.AT("a","123abc")
D.EMPTY(SPACE(10))
第9题
在下面的表达式中,运算结果为逻辑真的是A)EMPTY(.NULL.) B) LIKE("edit","edi?")C)AT("a","123abc") D)EMPTY(SPACE(10))
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!