1z0-062 Exam Question 136

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? (Choose three.)
  • 1z0-062 Exam Question 137

    You upgraded from a previous Oracle database version to Oracle Database version to
    Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load
    (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
    After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
    How do you accomplish this?
  • 1z0-062 Exam Question 138

    Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
    This consumes a lot of undo tablespace and generates lots of redo.
    Which two actions would you take to solve this problem? (Choose two.)
  • 1z0-062 Exam Question 139

    Examine the following parameters for a database instance:
    MEMORY_MAX_TARGET=0
    MEMORY_TARGET=0
    SGA_TARGET=0
    PGA_AGGREGATE_TARGET=500m
    Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?
    (Choose three.)
  • 1z0-062 Exam Question 140

    Which three activities are supported by the Data Recovery Advisor? (Choose three.)