Question 156

A databaseisstoredin an Automatic Storage Management (ASM) disk group,diskgroup, DGROUP1 with SQL:

Thereis enough free spacein the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
  • Question 157

    Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
    A user issues a query on a table on one of the PDBs and receives the following error:
    ERROR at line 1:
    ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp'
    ORA-27037: unable to obtain file status
    Identify two ways to rectify the error.
  • Question 158

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
    What should you use to achieve this?
  • Question 159

    The following parameter are set for your Oracle 12c database instance:
    OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
    OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
    You want to manage the SQL plan evolution task manually. Examine the following steps:
    1.Set the evolve task parameters.
    2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
    3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
    4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
    5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
    Identify the correct sequence of steps:
  • Question 160

    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
    The characteristics of the non-CDB are as follows:
    -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
    The characteristics of the CDB are as follows:
    -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
    Which technique should you use to minimize down time while plugging this non-CDB into the CDB?