Which three statements are true about Automatic Degree …

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

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 Manager’s Monitored SQL Executions page.

Explanation:
https://books.google.com.pk/books?id=iY8Mt8SbWicC&pg=PA619&lpg=PA619&dq=Oracle%27s+Auto+DOP
+algorithms+calculate+the+Degree+of+Parallelism+based+on+a+table%27s+block
+counts&source=bl&ots=2WytrJOjq&sig=wR8LwE3H4NgaDEZ8rQP8uVs2I1M&hl=en&sa=X&ved=0ahUKEwjb_8iSy_jXAhUGzRQKHdeCAg0Q
6AEIJzAA#v=onepage&q=Oracle’s%20Auto%20DOP%20algorithms%20calculate%20the%20Degree%20of%
20Parallelism%20based%20on%20a%20table’s%20block%20counts&f=false.