1z0-084

Review 114 1Z0-084 practice questions with answer explanations and community insights.

Question 1

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

  1. Create the KEEP cache and cache tables accessed by the SQL statements.
  2. Create the RECYCLE cache and cache tables accessed by the SQL statements.
  3. Increase the size of the library cache.
  4. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.
  5. Set the CURSOR_SHARING parameter to FORCE.

Question 2

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

  1. Parent and child latches
  2. Parent and child latches
  3. Optimizer execution plans
  4. Plan usage data
  5. Enqueue statistics
  6. Segment-level statistics

Question 3

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?

  1. COLUMN STORE COMPRESS FOR QUERY LOW
  2. ROW STORE COMPRESS
  3. ROW STORE COMPRESS ADVANCED
  4. COLUMN STORE COMPRESS FOR QUERY HIGH

Question 4

Examine this output of a query of V$PGA_TARGET_ADVICE: Which statements is true?

  1. With a target of 700 MB or more, all multipass executions work areas would be eliminated.
  2. PGA_AGGREGATE_TARGET should be set to at least 800 MB
  3. PGA_AGGREGATE_TARGET should be set to at least 700 MB.
  4. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

Question 5

Examine this statement and its corresponding execution plan: Which phase introduces the CONCATENATION step?

  1. SQL Semantic Check
  2. SQL Execution
  3. SQL Row Source Generation
  4. SQL Transformation
  5. SQL Adaptive Execution
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.