Oracle DBA 存储管理试题选.docx

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存储管理试题选相关内容: