Exam 1z0-064 topic 1 question 30 discussion

Actual exam question from Oracle's 1z0-064

Question #: 30
Topic #: 1

You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest
AWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time.
Which two can be reasons for this? (Choose two.)

A. The I/O performance is slow.
B. Bind variables are not used for similar queries, causing hard parses.
C. Repeated access to a small number of blocks.
D. Excessive time is spent on finding cached cursors in the library cache.
E. The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.

Show Suggested Answer

Suggested Answer: BC 🗳️

by iokan at Oct. 15, 2019, 2:22 p.m.

Comments

Submit Cancel

adz07

1 year ago

Selected Answer: BE

i agree with BE

upvoted 1 times

...

iokan

5 years, 3 months ago

I think the answer for this is B and E - cursor sharing is set to Exact.

upvoted 2 times

...

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 30 discussion

Comments

adz07

iokan

SY0-701