多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?()

  • A、remove the ORDER BY clause
  • B、remove the table alias prefix from the WHERE clause
  • C、remove the table alias from the SELECT clause
  • D、prefix the column in the USING clause with the table alias
  • E、prefix the column in the ORDER BY clause with the table alias
  • F、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"
正确答案:C,E
答案解析:
进入题库查看解析

微信扫一扫手机做题