1Z0-084Preview

The CURSOR_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an AWR report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses? (Choose two.)

Which three types of statistics are captured by Statspack with snap level 6? (Choose three.)

You execute the following:
EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

You want to reduce the amount of db file scattered read that is generated in the database.
You execute the SQL Tuning Advisor against the relevant workload.
Which two can be part of the expected result? (Choose two.)

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

Which two types of performance problems are reported by ADDM for PDBs? (Choose two.)

What is the right time to stop tuning an Oracle database?

Database performance degraded between 23:15 and 23:30 for the last three nights. The AWR snapshot interval is one hour. The ADDM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

Examine this AWR report excerpt:

You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?

Examine this output of a query of V$PGA_TARGET_ADVICE:

Which statements is true?

Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?