ExamTopics Logo
Mail Us[email protected]
Menu
 

1z0-084 Actual Exam Questions

Last updated on Dec. 19, 2024.
Vendor:Oracle
Exam Code:1z0-084
Exam Name:Oracle Database 19c: Performance Management and Tuning
Exam Questions:55
97% Passed the exam with this material
 

Topic 1 - Exam A

Question #1 Topic 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.)

  • A. Create the KEEP cache and cache tables accessed by the SQL statements.
  • B. Create the RECYCLE cache and cache tables accessed by the SQL statements.
  • C. Increase the size of the library cache.
  • D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.
  • E. Set the CURSOR_SHARING parameter to FORCE.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: CE 🗳️

Question #2 Topic 1

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

  • A. Parent and child latches
  • B. Parent and child latches
  • C. Optimizer execution plans
  • D. Plan usage data
  • E. Enqueue statistics
  • F. Segment-level statistics
Reveal Solution Hide Solution   Discussion   2

Correct Answer: CDE 🗳️

Question #3 Topic 1

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?

  • A. COLUMN STORE COMPRESS FOR QUERY LOW
  • B. ROW STORE COMPRESS
  • C. ROW STORE COMPRESS ADVANCED
  • D. COLUMN STORE COMPRESS FOR QUERY HIGH
Reveal Solution Hide Solution   Discussion   1

Correct Answer: C 🗳️

Question #4 Topic 1

Examine this output of a query of V$PGA_TARGET_ADVICE:

Which statements is true?

  • A. With a target of 700 MB or more, all multipass executions work areas would be eliminated.
  • B. PGA_AGGREGATE_TARGET should be set to at least 800 MB
  • C. PGA_AGGREGATE_TARGET should be set to at least 700 MB.
  • D. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: B 🗳️

file Viewing page 1 out of 14 pages.
Viewing questions 1-4 out of 55 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago