Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
A.
DROP emp_dept_vu;
B.
DELETE emp_dept_vu;
C.
REMOVE emp_dept_vu;
D.
DROP VIEW emp_dept_vu;
E.
DELETE VIEW emp_dept_vu;
F.
REMOVE VIEW emp_dept_vu;
Explanation:
DROP VIEW viewname;
Incorrect answer:
A:
Not a valid drop view statement
B:
Not a valid drop view statement
C:
Not a valid drop view statement
E:
Not a valid drop view statement
F:
Not a valid drop view statement
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 11-20