Oracle DBA认证考试存储管理试题及答案

时间:2024-08-14 23:46:46 Oracle认证 我要投稿
  • 相关推荐

Oracle DBA认证考试存储管理试题及答案

  Q. 1 : Oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.

Oracle DBA认证考试存储管理试题及答案

  1. True

  2. False

  2

  Q. 2 : Which of the following three portions of a data block are collectively called as Overhead.

  1. table directory, row directory and row data

  2. data block header, table diretory and free space

  3. table directory, row directory and data blcok header

  4. data block header, row data and row header

  3

  Q. 3 : Which portion of the data block contains table or index data

  1. table directory

  2. row directory

  3. overhead

  4. row data

  4

  Q. 4 : What are the two space management parameters for controling the use of free space in a data block

  1. INITIAL and NEXT

  2. PCTFREE and PCTUSED

  3. TABLESPACE and STORAGE

  4. free space cannot be controlled at block level

  2

  Q. 5 : The maximum number of transactions that a block can support is

  1. 100

  2. 255

  3. 1000

  4. unlimited

  2

  Q. 6 : what is PCTFREE

  1. A space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.

  2. A space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead.

  3. A space management parameter which tells Oracle that the block is available for inserts after the percentage of used memory falls below certain percentage.

  4. all of them

  1

  Q. 7 : What is the default value of NEXT parameter

  1. 1 block

  2. 2 blocks

  3. 5 blocks

  4. 100 blocks

  3

  Q. 8 : Which parameter reserves the more space for future updates

  1. high PCTINCREASE

  2. high PCTFREE

  3. high INITIAL

  4. high PCTUSED

  2

  Q. 9 : PCTFREE and PCTUSED together should not exceed

  1. 100

  2. 50

  3. 25

  4. 10

  1

  Q. 10 : Row migration is a result of

  1. not enough space in a block for new rows.

  2. not enough memory for sorts

  3. not enough space for updates in the current block

  4. all of them

  3

  Q. 11 : Frequent deallocation of extents result in

  1. truncated segments

  2. block fragmentation

  3. truncated tablespaces

  4. tablespace fragmentation

  4

  Q. 12 : Which background process coalesce the fragmented space

  1. SMON

  2. PMON

  3. DBWR

  4. LGWR

  1

  Q. 13 : Row migration is a result of

  1. high PCTFREE

  2. low PCTFREE

  3. high PCTUSED

  4. low PCTUSED

  2

《Oracle DBA认证考试存储管理试题及答案.doc》
将本文的Word文档下载到电脑,方便收藏和打印
推荐度:
点击下载文档

资深写手 • 1对1服务

文章代写服务

品质保证、原创高效、量身定制满足您的需求

点击体验

【Oracle DBA认证考试存储管理试题及答案】相关文章:

Oracle认证考试07-31

Oracle认证考试题库下载08-14

Oracle OCP认证考试题库09-20

Oracle认证考试相关08-01

Oracle认证考试介绍08-20

Oracle认证考试科目07-29

Oracle认证考试技巧09-21

oracle认证考试详情09-01

Oracle DBA职业要求10-28

2017年Oracle认证考试题库07-20

文章
代写

文章代写服务

资深写手 · 帮您写文章

品质保证、原创高效、量身定制满足您的需求

点击体验
ai帮你写文章
一键生成 高质量 不重复
微信扫码,即可体验

Oracle DBA认证考试存储管理试题及答案

  Q. 1 : Oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.

Oracle DBA认证考试存储管理试题及答案

  1. True

  2. False

  2

  Q. 2 : Which of the following three portions of a data block are collectively called as Overhead.

  1. table directory, row directory and row data

  2. data block header, table diretory and free space

  3. table directory, row directory and data blcok header

  4. data block header, row data and row header

  3

  Q. 3 : Which portion of the data block contains table or index data

  1. table directory

  2. row directory

  3. overhead

  4. row data

  4

  Q. 4 : What are the two space management parameters for controling the use of free space in a data block

  1. INITIAL and NEXT

  2. PCTFREE and PCTUSED

  3. TABLESPACE and STORAGE

  4. free space cannot be controlled at block level

  2

  Q. 5 : The maximum number of transactions that a block can support is

  1. 100

  2. 255

  3. 1000

  4. unlimited

  2

  Q. 6 : what is PCTFREE

  1. A space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.

  2. A space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead.

  3. A space management parameter which tells Oracle that the block is available for inserts after the percentage of used memory falls below certain percentage.

  4. all of them

  1

  Q. 7 : What is the default value of NEXT parameter

  1. 1 block

  2. 2 blocks

  3. 5 blocks

  4. 100 blocks

  3

  Q. 8 : Which parameter reserves the more space for future updates

  1. high PCTINCREASE

  2. high PCTFREE

  3. high INITIAL

  4. high PCTUSED

  2

  Q. 9 : PCTFREE and PCTUSED together should not exceed

  1. 100

  2. 50

  3. 25

  4. 10

  1

  Q. 10 : Row migration is a result of

  1. not enough space in a block for new rows.

  2. not enough memory for sorts

  3. not enough space for updates in the current block

  4. all of them

  3

  Q. 11 : Frequent deallocation of extents result in

  1. truncated segments

  2. block fragmentation

  3. truncated tablespaces

  4. tablespace fragmentation

  4

  Q. 12 : Which background process coalesce the fragmented space

  1. SMON

  2. PMON

  3. DBWR

  4. LGWR

  1

  Q. 13 : Row migration is a result of

  1. high PCTFREE

  2. low PCTFREE

  3. high PCTUSED

  4. low PCTUSED

  2