• 053(二十四)


    116、

    116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
    A. It can be used to back up all data on ASM disks.
    B. It can be used to recover the damaged ASM disk group along with the data.
    C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
    D. It can be used to re-create the ASM disk group with its attributes.
    Answer: CD
    View Code

    117、

    117.Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
    A. multiplexing of the control file
    B. adding the redo log member to the database
    C. database and operating system upgrades
    D. changing the database storage to ASM-managed storage
    Answer: CD 
    View Code

    118、

    118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
    A. SQL statements that are part of the AWR baseline only
    B. SQL statements based on the AWR top SQL identification
    C. SQL statements that are part of the available SQL Tuning Set (STS) only
    D. SQL statements that are available in the cursor cache and executed by a user other than SYS
    Answer: B
    View Code

    119、

    119.While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. 
    You have multiple destinations for archived redo log files. 
    What implications does it have on the backup of the flash recovery area?
    A. The backup fails because one of the archived redo log files is missing.
    B. The backup succeeds but it would be without the missing archived log.
    C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
    D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
    Answer: D
    View Code

    120、

    120.You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. 
    Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
    A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
    B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
    C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
    D. ASM compatibility controls which features for the ASM will be enabled.
    Answer: ABD 
    View Code
  • 相关阅读:
    盘点 Oracle 11g 中新特性带来的10大性能影响
    史上最全Oracle数据泵常用命令
    Oracle查看 open_cursors 和 session_cached_cursors
    SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl (Doc ID 2340986.1)
    FAQ: Oracle Flex ASM 12c / 12.1 (Doc ID 1573137.1)
    Test Case:: 12C ASM New feature (Doc ID 1571975.1)
    Test Case:: 12C ASMCMD New feature (Doc ID 1589249.1)
    如何在Oracle 12C中Drop/Truncate多个分区 (Doc ID 1482264.1)
    如何在Oracle 12C中添加多个分区 (Doc ID 1482456.1)
    12c分区增强功能,新功能(文档ID 1568010.1)
  • 原文地址:https://www.cnblogs.com/huanhuanang/p/5397624.html
Copyright © 2020-2023  润新知