Oracle
1Z0-064 · Question #33
1Z0-064 Question #33: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Question
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)
Options
- ADecreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the
- BA full table scan can become cheaper than index scans if the database instance has a high
- CIncreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the
- DIn DSS workloads where full table scans may run in parallel and bypass the buffer cache,
- EIncreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost
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.