Oracle
1Z0-117 · Question #104
1Z0-117 Question #104: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #104. The question stem and answer options stay visible for context.
Question
Examine the Exhibit 1 to view the structure of and indexes for EMPLOYEES and DEPARTMENTS tables. Which three statements are true regarding the execution plan?
Exhibits
Options
- AThe view operator collects all rows from a query block before they can be processed but higher operations
- BThe in-line query in the select list is processed as a view and then joined.
- CThe optimizer pushes the equality predicate into the view to satisfy the join condition.
- DThe optimizer chooses sort-merge join because sorting is required for the join equality predicate.
- EThe optimizer chooses sort-merge join as a join method because an equality predicate is used for joining
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.