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

Oracle认证考试

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

The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement? ()

  • A、The SQL statement displays the desired results.
  • B、The column in the WHERE clause should be changed to display the desired results.
  • C、The operator in the WHERE clause should be changed to display the desired results.
  • D、The WHERE clause should be changed to use an outer join to display the desired results.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题