<dfn id="w48us"></dfn><ul id="w48us"></ul>
  • <ul id="w48us"></ul>
  • <del id="w48us"></del>
    <ul id="w48us"></ul>
  • 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認證考試存儲管理試題及答案】相關文章:

    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

    主站蜘蛛池模板: 亚洲中文久久精品无码| HEYZO无码综合国产精品| 日韩精品无码一区二区三区不卡| 久久亚洲精品视频| 少妇人妻无码精品视频app| 国产精品久久久久久久午夜片| 精品深夜AV无码一区二区| 免费精品视频在线| 99热这里只有精品6国产免费| 精品日韩亚洲AV无码 | 久久精品国产精品亚洲毛片| 久久精品亚洲精品国产欧美| 国产精品自产拍在线观看| 无码精品人妻一区二区三区免费看 | 久草视频精品在线| 亚洲国语精品自产拍在线观看| 国产网红无码精品视频| 亚洲欧美日韩精品久久亚洲区| 蜜桃麻豆www久久国产精品 | 中文字幕精品无码一区二区| 精品久久久久久国产牛牛app| 四虎国产精品永久地址99| 国产精品久久影院| 久久精品人人做人人妻人人玩 | 亚洲欧美一级久久精品| 久热精品视频第一页| 国产情侣大量精品视频| 国产高清日韩精品欧美激情| 亚洲精品天天影视综合网| 久久久久四虎国产精品| 精品无人区麻豆乱码1区2区 | 精品无码AV无码免费专区| 亚洲AV永久无码精品成人| 一本之道av不卡精品| 真实国产乱子伦精品一区二区三区| 日韩精品毛片| 四虎国产精品免费久久| 亚洲成人国产精品| 亚洲日韩精品无码专区网站| 无码精品A∨在线观看中文| 亚洲AV无码国产精品麻豆天美|