<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

    主站蜘蛛池模板: 色欲精品国产一区二区三区AV| 国产精品 猎奇 另类视频| 久久精品9988| 亚洲精品无码永久在线观看| 精品一区二区三区免费| 无码国内精品人妻少妇| 久久99精品国产麻豆蜜芽| 免费欧美精品a在线| 国产精品无码av在线播放| 亚洲精品视频免费观看| 精品人妻伦九区久久AAA片69| 久久久精品午夜免费不卡| 国产午夜无码精品免费看动漫| 亚洲国产精品成人一区 | 国产一成人精品福利网站| 午夜精品久久久久久久久| 久久精品国产一区二区电影| 99精品视频在线观看婷| 久久亚洲精品视频| 99国产欧美久久久精品蜜芽| 久久亚洲精品成人av无码网站| 中国大陆精品视频XXXX| 无码8090精品久久一区| 久久久久亚洲精品男人的天堂| 国产精品美女久久久久AV福利 | 少妇人妻无码精品视频app| 亚洲精品国产精品乱码不卞| 女人高潮内射99精品| 久久久久无码国产精品不卡| 久久精品亚洲男人的天堂| 久久成人精品| 久久久久成人精品无码| 久久93精品国产91久久综合| 久久精品一区二区三区中文字幕| 精品国产黑色丝袜高跟鞋| 久久精品99无色码中文字幕| 久久se精品一区二区影院 | 精品国产v无码大片在线观看| 无码国内精品人妻少妇| 久久久久人妻精品一区二区三区| 热re99久久6国产精品免费|