View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id…

Question

Exhibit

Options

• AThe statement would execute successfully and display all the rows in the ascending order of
• BThe statement would execute successfully but it will ignore the ORDER BY clause and display the
• CThe statement would not execute because the positional notation instead of the column name should
• DThe statement would not execute because the ORDER BY clause should appear only at the end of

• A
  3% (1)
• B
  15% (5)
• C
  9% (3)
• D
  73% (24)

No community discussion yet for this question.