Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

Oracle 1z0-084 Exam Actual Questions

The questions for 1z0-084 were last updated on Sept. 14, 2024.
  • Viewing page 1 out of 14 pages.
  • Viewing questions 1-4 out of 55 questions
 

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  

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  

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  

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  

Correct Answer: B 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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.

SaveCancel