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

The correct answer is D. DROP VIEW emp_dept_vu. 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

Creating and Managing Schema Objects

Question

Options

ADROP emp_dept_vu;
BDELETE emp_dept_vu;
CREMOVE emp_dept_vu;
DDROP VIEW emp_dept_vu;
EDELETE VIEW emp_dept_vu;
FREMOVE VIEW emp_dept_vu;

How the community answered

(27 responses)

A
4% (1)
C
11% (3)
D
81% (22)
F
4% (1)

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

Topics

#DROP VIEW#DDL#view management#schema objects

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice