Oracle
1Z0-061 · Question #220
Examine the structure of the EMP_DEPT_VU view: Which SQL statement produces an error?
The correct answer is E. None of the statements produce an error; all are valid. See the full explanation below for the reasoning.
Question
Examine the structure of the EMP_DEPT_VU view:
Which SQL statement produces an error?
Exhibit
Options
- ASELECT *
- BSELECT department_id, SUM(salary)
- CSELECT department_id, job_id, AVG(salary)
- DSELECT job_id, SUM(salary)
- ENone of the statements produce an error; all are valid.
How the community answered
(23 responses)- B9% (2)
- C4% (1)
- D4% (1)
- E83% (19)
Community Discussion
No community discussion yet for this question.