Home » Oracle » 1z0-061 » 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;
Correct Answer: D
Explanation/Reference:
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
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
