Oracle
1Z0-007 · Question #153
1Z0-007 Question #153: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.
Question
The EMP table contains these columns: 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 DEPARTMENT_ID = NULL; What is true about this SQL statement?
Options
- AThe SQL statement displays the desired results.
- BThe column in the WHERE clause should be changed to display the desired results.
- CThe operator in the WHERE clause should be changed to display the desired results.
- DThe WHERE clause should be changed to use an outer join to display the desired results.
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.