The correct answer is option D (DROP VIEW emp_dept_vu). We can use a DROP statement to remove a view from the database. Here is the syntax to remove the view created:
DROP VIEW view_name;
If you are interested in SQL, then sign up for this SQL Certification course by Intellipaat that offers instructor-led training, certification, and job assistance.