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

Question

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

• A
  82% (28)
• D
  6% (2)
• E
  9% (3)
• F
  3% (1)

No community discussion yet for this question.