Oracle
1Z0-882 · Question #56
1Z0-882 Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Question
A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown: You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the effect of adding STRAIGHT JOINs to the query?
Options
- AThe optimizer processes only the JOINs in the sequence listed in the query.
- BThe optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.
- CThe optimizer will only JOIN the tables in sequence from smallest to largest.
- DThe optimizer ignores all terms in the WHERE clause until all JOINs have been completed.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.