Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
The solution that best optimizes one SQL statement can degrade the performance of others. This is true because optimization often involves trade-offs, and improving performance for one query may negatively affect others due to resource contention or changes in execution plans. Poorly performing SQL statements can be tuned automatically by the Oracle server. Oracle provides tools and features such as the Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor, which can automatically identify and suggest improvements for poorly performing SQL statements.
Of course C and E
I think CE
Go with C, E
CE but not so obvious.
CE, The other one answer are not true.
Sure of CE
C,E Correct