Database Management
primer-original-v2mediumDatabase Management08 Dcl & Database Objectsprimer-original-v2

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

Answer options

A
DROP VIEW emp_dept_vu;
B
DELETE VIEW emp_dept_vu;
C
REMOVE VIEW emp_dept_vu;
D
ALTER VIEW emp_dept_vu DROP;

Correct answer: DROP VIEW emp_dept_vu;

Explanation

Quick AnswerThe correct answer is DROP VIEW emp_dept_vu; because it directly addresses the core logic of Database Management.

This question has been retained as-is due to its unique context.

Related Database Management questions

Practice more Database Management questions

PrimerPrep has independently reviewed practice questions and coding exercises — all free.