Question 31

You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
  • Question 32

    Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)
  • Question 33

    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
    Examine the following command and its output:

    What does this imply?
  • Question 34

    Examine the query and its output executed In an RDBMS Instance:

    Which three statements are true about the users (other than sys) in the output?
  • Question 35

    While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAILview was queried.
    How can you ensure that all available audit records are returned when the audit trail is queried?