Oracle DBA 存储管理试题选.docx
- 文档编号:30134246
- 上传时间:2023-08-05
- 格式:DOCX
- 页数:8
- 大小:14.92KB
Oracle DBA 存储管理试题选.docx
《Oracle DBA 存储管理试题选.docx》由会员分享,可在线阅读,更多相关《Oracle DBA 存储管理试题选.docx(8页珍藏版)》请在冰豆网上搜索。
OracleDBA存储管理试题选
OracleDBA存储管理试题选
OracleDBA存储管理试题选OracleDBA存储管理试题选q.1:
oracleimmediatelyre-usesthespaceassignedtorow-directoryportionofthedatablockonceyoudeletethecorrespondingrows.
1.true
2.false
2
q.2:
whichofthefollowingthreeportionsofadatablockarecollectivelycalledasoverhead.
1.tabledirectory,rowdirectoryandrowdata
2.datablockheader,tablediretoryandfreespace
3.tabledirectory,rowdirectoryanddatablcokheader
4.datablockheader,rowdataandrowheader
3
q.3:
whichportionofthedatablockcontainstableorindexdata
1.tabledirectory
2.rowdirectory
3.overhead
4.rowdata
4
q.4:
whatarethetwospacemanagementparametersforcontrolingtheuseoffreespaceinadatablock
1.initialandnext
2.pctfreeandpctused
3.tablespaceandstorage
4.freespacecannotbecontrolledatblocklevel
2
q.5:
themaximumnumberoftransactionsthatablockcansupportis
1.100
2.255
3.1000
4.unlimited
2
q.6:
whatispctfree
1.aspacemanagementparameterwhichsetsasidethatmuchpercentageofmemoryinthedatablockforfutureupdateofexistingrows.
2.aspacemanagementparameterwhichdeterminestheminimumpercentageofablockthatcanbeusedforrowdataplusoverhead.
3.aspacemanagementparameterwhichtellsoraclethattheblockisavailableforinsertsafterthepercentageofusedmemoryfallsbelowcertainpercentage.
4.allofthem
1
q.7:
whatisthedefaultvalueofnextparameter
1.1block
2.2blocks
3.5blocks
4.100blocks
3
q.8:
whichparameterreservesthemorespaceforfutureupdates
1.highpctincrease
2.highpctfree
3.highinitial
4.highpctused
2
q.9:
pctfreeandpctusedtogethershouldnotexceed
1.100
2.50
3.25
4.10
1
q.10:
rowmigrationisaresultof
1.notenoughspaceinablockfornewrows.
2.notenoughmemoryforsorts
3.notenoughspaceforupdatesinthecurrentblock
4.allofthem
3
q.11:
frequentdeallocationofextentsresultin
1.truncatedsegments
2.blockfragmentation
3.truncatedtablespaces
4.tablespacefragmentation
4
q.13:
rowmigrationisaresultof
1.highpctfree
2.lowpctfree
3.highpctused
4.lowpctused
2
q.12:
whichbackgroundprocesscoalescethefragmentedspace
1.smon
2.pmon
3.dbwr
4.lgwr
q.1:
oracleimmediatelyre-usesthespaceassignedtorow-directoryportionofthedatablockonceyoudeletethecorrespondingrows.
1.true
2.false
2
q.2:
whichofthefollowingthreeportionsofadatablockarecollectivelycalledasoverhead.
1.tabledirectory,rowdirectoryandrowdata
2.datablockheader,tablediretoryandfreespace
3.tabledirectory,rowdirectoryanddatablcokheader
4.datablockheader,rowdataandrowheader
3
q.3:
whichportionofthedatablockcontainstableorindexdata
1.tabledirectory
2.rowdirectory
3.overhead
4.rowdata
4
q.4:
whatarethetwospacemanagementparametersforcontrolingtheuseoffreespaceinadatablock
1.initialandnext
2.pctfreeandpctused
3.tablespaceandstorage
4.freespacecannotbecontrolledatblocklevel
2
q.5:
themaximumnumberoftransactionsthatablockcansupportis
1.100
2.255
3.1000
4.unlimited
2
q.6:
whatispctfree
1.aspacemanagementparameterwhichsetsasidethatmuchpercentageofmemoryinthedatablockforfutureupdateofexistingrows.
2.aspacemanagementparameterwhichdeterminestheminimumpercentageofablockthatcanbeusedforrowdataplusoverhead.
3.aspacemanagementparameterwhichtellsoraclethattheblockisavailableforinsertsafterthepercentageofusedmemoryfallsbelowcertainpercentage.
4.allofthem
1
q.7:
whatisthedefaultvalueofnextparameter
1.1block
2.2blocks
3.5blocks
4.100blocks
3
q.8:
whichparameterreservesthemorespaceforfutureupdates
1.highpctincrease
2.highpctfree
3.highinitial
4.highpctused
2
q.9:
pctfreeandpctusedtogethershouldnotexceed
1.100
2.50
3.25
4.10
1
q.10:
rowmigrationisaresultofOracleDBA存储管理试题选相关内容:
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle DBA 存储管理试题选 存储 管理 试题