<dfn id="w48us"></dfn><ul id="w48us"></ul>
  • <ul id="w48us"></ul>
  • <del id="w48us"></del>
    <ul id="w48us"></ul>
  • Oracle OCP認證考試題庫解析

    時間:2024-08-27 19:11:46 Oracle認證 我要投稿
    • 相關推薦

    2017年Oracle OCP認證考試題庫解析

      Oracle公司頒布并實施的一項權威品的服務與支持。并具有嫻熟的專業技術標準,它是專為認證那些有操作能力與廣泛理論知識的專業人。下面是小編整理的Oracle OCP認證考試題庫解析,歡迎大家參考!

    2017年Oracle OCP認證考試題庫解析

      QUESTION 1

      You notice that the performance of the database has degraded because of frequent checkpoints.

      Which two actions resolve the issue? (Choose two.)

      A. Disable automatic checkpoint tuning

      B. Check the size of the redo log file size and increase the size if it is small

      C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

      D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

      Correct Answer: BC

      Explanation/Reference:

      檢查點進程:

      The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, location in online redo log to begin recovery, and so on. CKPT does not write data blocks to data files or redo blocks to online redo log files.

      檢查點作用:

      (1)定期促進DBWn進程把內存的臟塊寫回到數據文件,數據庫故障時不會丟數據

      (2)減少實例恢復的時間

      (3)確保所有已提交的數據在一致性關閉期間會被寫入數據文件

      實例恢復時間:

      指的是將數據文件的最后一個檢查點(檢查點位置)推進到控制文件中記錄的最新SCN所需的時間.管理員可以通過設置MTTR 目標以及調整重做日志組的大小來控制該時間.

      MTTR:

      Mean Time To Repair,即平均修復時間.是指可修復產品的平均修復時間,就是從出現故障到修復中間的這段時間.MTTR越短表示易恢復性越好.在數據庫中可以通過設置參數FAST_START_MTTR_TARGET(單位為秒),控制數據庫對單個實例執行崩潰恢復所花費的時間.

      FAST_START_MTTR_TARGE=非0值, 啟用快速啟動檢查點功能,自動控制發檢查點速度.

      FAST_START_MTTR_TARGE=0,禁用快速啟動檢查點功能.

      如果重做日志文件的size太小,會頻繁切換日志,即會頻繁發生檢查點,故可以增大重做日志文件的size減少檢查點發生頻率.

      FAST_START_MTTR_TARGET如果設置的太小,為了要控制數據庫單實例的實例恢復時間,則必須頻繁發生檢查點,確保內存中已修改的數據塊能夠定期寫入到磁盤,故可以使用MTTR Advisor來設置推薦的值.

      QUESTION 2

      Identify the memory component from which memory may be allocated for:Session memory for the shared server, Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and restore operations

      A. Large Pool

      B. Redo Log Buffer

      C. Database Buffer Cache

      D. Program Global Area (PGA)

      Correct Answer: A

      Explanation/Reference:

      Large Pool

      The large pool is an optional memory area intended for memory allocations that are larger than is appropriate for the shared pool. The large pool can provide large memory allocations for the following:

      UGA for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)

      Message buffers used in the parallel execution of statements

      Buffers for Recovery Manager (RMAN) I/O slaves

      By allocating session memory from the large pool for shared SQL, the database avoids performance overhead caused by shrinking the shared SQL cache. By allocating memory in large buffers for RMAN operations, I/O server processes, and parallel buffers, the large pool can satisfy large memory requests better than the shared pool.

      QUESTION 3

      You executed the following command to create a tablespace called SALES_DATA:

      SQL> CREATE TABLESPACE sales_data

      DATAFILE SIZE 100M

      SEGMENT SPACE MANAGEMENT AUTO;

      Which two statements are true about the SALES_DATA tablespace? (Choose two)

      A. The database automatically determines the extent-sizing policy for the tablespace.

      B. The segments are automatically shrunk when the contents are removed from them.

      C. The allocation of extents within the tablespace is managed through the dictionary tables.

      D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

      E. The space utilization description of the data blocks in segments is managed through free lists.

      Correct Answer: AD

      Explanation/Reference:

      段空間管理: 本地管理的表空間中的段空間管理方式可指定為:

      自動:Oracle DB 使用位圖管理段中的空閑空間.位圖描述了段中每個數據塊的狀態,該狀態與可插入行的塊中的空間量有關.當數據塊中可用空間增多或減少時,位圖中會反映數據塊的新狀態.通過使用位圖,Oracle DB 可以提高管理空閑空間的自動化程度.因此,這種空間管理方式稱為"自動段空間管理(ASSM)".

      手動:此方法指定要使用空閑列表來管理段中的空閑空間.空閑列表是由一些數據塊組成的列表,這些數據塊中有可插入行的空間.由于這種管理段空間的方式需要為在表空間中創建的方案對象指定并優化PCTUSED、FREELISTS和FREELIST GROUPS存儲參數,因此這種方式稱為"手動段空間管理".支持使用此方法是為了向后兼容,建議使用ASSM.

      可通過dba_tablespaces查看分區和段空間管理方式:

      SYS@ENMOEDU> select tablespace_name,extent_management,segment_space_management from dba_tablespaces;

      TABLESPACE_NAME EXTENT_MAN SEGMEN

      ---------------- ---------- ------

      SYSTEM LOCAL MANUAL

      SYSAUX LOCAL AUTO

      TEMP LOCAL MANUAL

      USERS LOCAL AUTO

      EXAMPLE LOCAL AUTO

      UNDOTBS1 LOCAL MANUAL

      QUESTION 4

      In which of the scenario will the DBA perform recovery? (Choose all that apply.)

      A. The alert log file is corrupted

      B. A tablespace is accidentally dropped

      C. One of the redo log members is corrupted

      D. A database user terminates the session abnormally

      E. The hard disk on which the data files is stored is corrupted

      Correct Answer: BE

      Explanation/Reference:

      DBA一般在數據庫出現介質損壞的時候執行恢復操作.

      A: 錯誤,alert日志損壞數據庫不會丟失數據,不需要恢復.

      B: 正確,表空間在操作系統改名需要執行恢復,數據庫找不到表空間對應的數據文件.

      C: 錯誤,丟失redo成員,不會丟失數據,不需要執行恢復操作.

      D: 錯誤,會話異常終止不會丟失數據,不需要恢復,數據庫會釋放異常會話占用的資源.

      E: 正確,磁盤損壞會導致在該磁盤的數據文件損壞,需要執行恢復操作.

    【Oracle OCP認證考試題庫解析】相關文章:

    Oracle OCP認證考試題庫12-31

    Oracle OCP認證要通過哪些考試08-17

    Oracle認證考試技巧09-21

    Oracle認證考試相關08-01

    oracle認證考試詳情01-22

    Oracle認證考試指南09-23

    Oracle認證作用07-31

    Oracle最新認證07-13

    Oracle認證簡介11-30

    Oracle認證途徑09-11

    主站蜘蛛池模板: 国产精品男男视频一区二区三区| 另类国产精品一区二区| 91亚洲国产成人久久精品网址| 一本久久a久久精品综合香蕉| 久久99精品久久久久久| 欧美日韩精品一区二区三区不卡 | 久久久久夜夜夜精品国产| 日韩欧美亚洲国产精品字幕久久久| 国产福利视精品永久免费| 亚洲精品视频在线观看你懂的| 国产成人久久久精品二区三区| 国产精品视频网站你懂得| 一本之道av不卡精品| 久久国产精品免费一区| 国产成人精品久久亚洲高清不卡| 91久久精品91久久性色| 日韩国产成人精品视频 | 中文字幕精品久久久久人妻| 国产精品一区二区三区免费| 亚洲国产精品线在线观看| 91麻豆精品视频在线观看| 久久久国产精品亚洲一区| 亚洲精品成人片在线观看| 国产一区二区精品久久凹凸| 91精品久久久久久无码| 99RE6热在线精品视频观看| 久久久久人妻一区精品性色av| 亚洲无码日韩精品第一页| 精品国产福利尤物免费| 99久久国产主播综合精品| 欧美大片日韩精品| 国产夫妇精品自在线| 国产成人精品免费视频网页大全| 国产精品久久久久jk制服| 国产三级精品三级在线专区1| 久久亚洲精品成人AV| 十八18禁国产精品www| 亚洲国产另类久久久精品小说| 亚洲国产主播精品极品网红| 亚洲精品第一国产综合精品99| 麻豆精品视频在线观看91|