Oracle Service Cloud Developer — Question 20

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

Answer options

• A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
• B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
• C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.
• D. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.
• E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.
• F. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise

Correct answer: A, B, C

Explanation

The correct options A, B, and C reflect the true nature of Auto DOP, where it is enabled through a specific parameter, uses block counts to determine parallelism, and is disabled by default. Options D and E are incorrect as they misrepresent the default status and capabilities of Auto DOP, while option F does not directly address the characteristics of Auto DOP itself.