Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

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:
ANot a valid drop view statement
BNot a valid drop view statement
CNot a valid drop view statement
ENot a valid drop view statement
FNot a valid drop view statement

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 11-20



Leave a Reply 0

Your email address will not be published. Required fields are marked *