Question 126

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?
  • Question 127

    In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
    SQL > REVOKE create table FROM C # # A_ADMIN;
    What is the result?
  • Question 128

    The following parameters are set for your Oracle 12c database instance:

    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_TASKfunction.
    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_TASKfunction.
    5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASKfunction.
    Identify the correct sequence of steps:
  • Question 129

    Which two statements are true about Oracle Direct Network File System (NFS)? (Choose two.)
  • Question 130

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
    All databases of all versions use Automatic Storage Management (ASM).
    Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)