Oracle
1Z0-064 · Question #74
1Z0-064 Question #74: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events: Identify three possible reasons for the increased response time. (Choose three.)
Options
- Atoo many sort operations being performed
- Brepeated simultaneous access to a block or small number of blocks
- Cthe shared pool is inadequately sized
- Dqueries not using indexes and performing full table scans
- Equeries repeatedly fetching blocks that are not in the database buffer cache
- Fcursors are closed explicitly after each execution
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.