Oracle
1Z0-338 · Question #37
1Z0-338 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-338 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
Question
Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)
Options
- AAuto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
- BOracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
- CAuto DOP is disabled by default, and must be enabled before SQL statements can take advantage of
- DAuto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement
- EAuto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its
- FThe SQL statements that take advantage of Auto DOP can be identified by using data from Oracle
Unlock 1Z0-338 to see the answer
You've previewed enough free 1Z0-338 questions. Unlock 1Z0-338 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.