Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)

Question

Options

• ASQL statements performing many physical I/Os can always have their performance improved by
• BSQL statements doing only logical reads never require tuning because they do no physical I/O.
• CThe solution that best optimizes one SQL statement can degrade the performance of others.
• DSQL statements doing joins always do more physical I/O than single table queries.
• EPoorly performing SQL statements can be tuned automatically by the Oracle server.

• A
  8% (2)
• B
  4% (1)
• C
  72% (18)
• D
  16% (4)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#PFGRF028

No community discussion yet for this question.