Question 136

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. Set the 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 137

    Examine the output:
    SQL> ARCHIVE LOG LIST
    Database log modeArchive Mode
    Automatic archival Enabled
    Archive DestinationUSE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence376
    Next log sequence to archive378
    Current log sequence378
    Which three types of files are automatically placed in the fast recovery area? (Choose three.)
  • Question 138

    In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
    $> sqlldr hr/hr@pdb table=employees
    Which three are true? (Choose three.)
  • Question 139

    You use RMAN to take regular backups for your database.
    Examine the RMAN commands:
    RMAN> CROSSCHECK BACKUP;
    RMAN> DELETE EXPITED BACKUP;
    Which statement is true?
  • Question 140

    Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
    SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;
    SQL> CREATE ROLE c##role1 CONTAINER=ALL;
    SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
    SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
    SQL> REVOKE c##role1 FROM c##a_admin;
    What is the result of the revoke command?