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?

Question

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

• A
  11% (2)
• B
  78% (14)
• D
  11% (2)

No community discussion yet for this question.