Examine the query and its execution plan: Which statement is true regarding the execution plan?

Question

Exhibit

Options

• AThis query first fetches rows from the CUSTOMERS table that satisfy the conditions, and then the join
• BThe query fetches rows from CUSTOMERS and ORDERS table simultaneously, and filters the rows
• CThe query first fetches rows from the ORDERS table that satisfy the conditions, and then the join returns
• DThe query first joins rows from the CUSTOMERS and ORDERS tables and returns NULL for the ORDERS

• A
  80% (24)
• B
  3% (1)
• C
  3% (1)
• D
  13% (4)

No community discussion yet for this question.