免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1354 | 回复: 0

510-022题库下载 [复制链接]

论坛徽章:
0
发表于 2011-02-13 08:40 |显示全部楼层
<p align="left"><p align="left">最新510-022题分享</p></p><p align="left"><p align="left">1. Which of the following pages is NOT found on an allocation unit?</p></p><p align="left"><p align="left">A. Data</p></p><p align="left"><p align="left">B. Index</p></p><p align="left"><p align="left">C. OAM</p></p><p align="left"><p align="left">D. GAM</p></p><p align="left"><p align="left">E. Control</p></p><p align="left"><p align="left">F. None of the above</p></p><p align="left"><p align="left">Answer: E</p></p><p align="left"><p align="left">2. The first page on a device fragment must? (Choose 2)</p></p><p align="left"><p align="left">A. be listed in the lstart column of sysusages.</p></p><p align="left"><p align="left">B. be listed in the low column of sysdevices.</p></p><p align="left"><p align="left">C. be an OAM page.</p></p><p align="left"><p align="left">D. be an allocation page.</p></p><p align="left"><p align="left">E. have a logical page number that is a multiple of 1024.</p></p><p align="left"><p align="left">Answer: AD</p></p><p align="left"><p align="left">3. How many allocation pages are created in a 4 MB database (assuming 4K page size)?</p></p><p align="left"><p align="left">A. 2</p></p><p align="left"><p align="left">B. 4</p></p><p align="left"><p align="left">C. 8</p></p><p align="left"><p align="left">D. 16</p></p><p align="left"><p align="left">Answer: B</p></p><p align="left"><p align="left">4.Consider the following page header: PAGE HEADER: pageno=720 nextpg=0 prevpg=0</p></p><p align="left"><p align="left">objid=64000228 timestamp=0000 000022b5 nextrno=5 level=0 indid=0 freeoff=150 minlen=6</p></p><p align="left"><p align="left">How many data rows are currently on this page?</p></p><p align="left"><p align="left">A. 0</p></p><p align="left"><p align="left">B. 3</p></p><p align="left"><p align="left">C. 4</p></p><p align="left"><p align="left">D. 5</p></p><p align="left"><p align="left">E. 6</p></p><p align="left"><p align="left">F. Unknown</p></p><p align="left"><p align="left">Answer: F</p></p><p align="left"><p align="left">5. Whcih SQL statement finds the first page of sysgams&quot;</p></p><p align="left"><p align="left">A. select first from sysobjects where id = object_id(&quot;sysgams&quot</p></p><p align="left"><p align="left">B. select first from sysindexes where id = object_id(&quot;sysgams&quot</p></p><p align="left"><p align="left">C. select first from syscolumns where id = object_id(&quot;sysgams&quot</p></p><p align="left"><p align="left">D. select first from sysgams</p></p><p align="left"><p align="left">Answer: B</p></p><p align="left"><p align="left">6. All of the following are causes of fragmentation in a table EXCEPT</p></p><p align="left"><p align="left">A. no clustered index</p></p><p align="left"><p align="left">B. page splits</p></p><p align="left"><p align="left">C. row level locking</p></p><p align="left"><p align="left">D. too many indexes</p></p><p align="left"><p align="left">Answer: D</p></p><p align="left"><p align="left">7. Given the following information from an allocation page, which of the following is NOT true?</p></p><p align="left"><p align="left">OAMPG:5121 Extent ID 5336 Object ID is 1264004503 Index ID is 2 Allocation bitmap: 0xff</p></p><p align="left"><p align="left">A. None of the pages of this extent are in use.</p></p><p align="left"><p align="left">B. The OAM page for this table is page 5121.</p></p><p align="left"><p align="left">C. This table has a nonclustered index.</p></p><p align="left"><p align="left">D. The first page of this extent is 5336.</p></p><p align="left"><p align="left">Answer: A</p></p><p align="left"><p align="left">8. How are OAM pages linked?</p></p><p align="left"><p align="left">A. Each OAM page is linked to its allocation page.</p></p><p align="left"><p align="left">B. Linear page chain for APL; not linked for DOL.</p></p><p align="left"><p align="left">C. No more than one OAM page per object, so no chain.</p></p><p align="left"><p align="left">D. OAM pages are circularly linked.</p></p><p align="left"><p align="left">Answer: D</p></p><p align="left"><p align="left">9. Which of the following is the minimum size for object allocation for ASE 12.5 with a logical page size of 16K?</p></p><p align="left"><p align="left">A. 16K</p></p><p align="left"><p align="left">B. 32K</p></p><p align="left"><p align="left">C. 64K</p></p><p align="left"><p align="left">D. 128K</p></p><p align="left"><p align="left">Answer: D</p></p><p align="left"><p align="left">10. How would you locate the first OAM page for a given table?</p></p><p align="left"><p align="left">A. has no fixed addresses</p></p><p align="left"><p align="left">B. listed in sysindexes.</p></p><p align="left"><p align="left">C. listed in sysobjects</p></p><p align="left"><p align="left">D. listed in the GAM page</p></p><p align="left"><p align="left">Answer: B</p></p>
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP