Which SQL statement would you use to remove a view call…

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



Leave a Reply 0

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