Multiple choice softskills teamwork

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

  1. DROP emp_dept_vu;

  2. DELETE emp_dept_vu;

  3. REMOVE emp_dept_vu;

  4. DROP VIEW emp_dept_vu;

  5. DELETE VIEW emp_dept_vu;

  6. REMOVE VIEW emp_dept_vu;
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The DROP VIEW statement removes a view from the schema by deleting its definition from the data dictionary. DELETE removes data from tables, not schema objects. REMOVE is not a valid SQL command. The syntax requires both DROP VIEW and the view name.

AI explanation

"DROP VIEW emp_dept_vu;" is the correct SQL statement to remove a view, because DROP VIEW is the specific DDL command for permanently deleting a view object from the schema. "DROP emp_dept_vu;" is missing the required object-type keyword VIEW, so it's invalid syntax (DROP alone needs to know what kind of object to drop). "DELETE" and "REMOVE" (with or without VIEW) are not valid SQL keywords for dropping schema objects — DELETE only removes rows from a table's data, not the object definition itself, and REMOVE isn't a SQL keyword at all in standard/Oracle SQL.

Keep practicing — related questions