The SQL statement used to modify a view is ________.
A) ALTER EXISTING VIEW ViewName AS
B) ALTER VIEW ViewName AS
C) DROP EXISTING VIEW ViewName
D) DROP VIEW ViewName
E) MODIFY VIEW ViewName AS

Question

Quizplus · Accepted Answer

The SQL statement to modify a view is ALTER VIEW ViewName AS. This statement allows the user to modify the SELECT statement used to create the view. The other options, such as DROP VIEW and ALTER EXISTING VIEW, do not serve the purpose of modifying a view. MODIFY VIEW is not a valid SQL statement.

The SQL Statement Used to Modify a View Is ________