1Z1-060 Exam Question 86

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.
Which option would solve this problem?
  • 1Z1-060 Exam Question 87

    To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:

    SQL > startup
    ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
    Identify the reason the instance failed to start.
  • 1Z1-060 Exam Question 88

    Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
  • 1Z1-060 Exam Question 89

    Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

    Which two statements are true?
  • 1Z1-060 Exam Question 90

    Which two statements are true about the RMAN VALIDATE DATABASEcommand? (Choose two.)