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.)

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?
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.)
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.)
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.)