Question 136

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
  • Question 137

    You are connected to a recovery catalog and target database. You execute the command:
    RMAN> CATALOG START WITH '/disk1/backups';
    Which statement is true?
  • Question 138

    In which two locations does the USER_DATA TABLESPACE clause create a tablespace?
  • Question 139

    The following parameters 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.Setthe evolve task parameters.
    2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_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 140

    You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

    Which statement is true about the execution of the last command?