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

Question

Exhibit

Options

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

• A
  9% (4)
• B
  16% (7)
• C
  2% (1)
• D
  73% (32)

No community discussion yet for this question.