Oracle
1Z0-064 · Question #7
1Z0-064 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Question
You recently joined a new team administering a database. You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job. You decide that performance problems are caused by a misconfiguration of factors affecting full table scans. Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
Options
- Avalue of DB_FILE_MULTIBLOCK_READ_COUNT
- Bstoring query results in the result cache
- Csetting of the DISK_ASYNC_IO parameter to TRUE
- Dsetting of the OPTIMIZER_MODE parameter to ALL_ROWS
- Euse of parallel queries
- Fblock size of the tablespaces in which the tables being scanned are stored
- Gvalue of the OPTIMIZER_DYNAMIC_SAMPLING parameter
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.