Database Management
Accenture Technical PrimermediumDatabase Management08 Dcl & Database Objects

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.

DROP VIEW is the correct SQL syntax to remove a view.

Related Accenture Database Management questions

Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and l…In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?Which of the following is not a valid relational database?Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True o…Which of the following represents the degree of the relation?A table consists of ______ primary keys.

Practice more Accenture Database Management questions

PrimerPrep has 1400+ practice questions, 2026 simulations and coding hands-on — all free.

Database Management practice setAll subjects
Watch Walkthroughs!