Question 51

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
  • Question 52

    Examine the following impdp command to import a database over the network from a pre-
    12c Oracle database (source):

    Which three are prerequisites for successful execution of the command?
  • Question 53

    You use a recovery catalog for maintaining your database backups.
    You execute the following command:
    $rman TARGET / CATALOG rman / cat@catdb
    RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
    Which two statements are true?
  • Question 54

    You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
    You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
    Which three findings would you get from the report? (Choose three.)
  • Question 55

    Your database supports a DSS workload that involves the execution of complex queries:
    Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
    What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?