Oracle
1Z0-083 · Question #116
1Z0-083 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
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.
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.