Which of the following is the correct syntax to change the query inside an existing view named employee_view?

easy📝 Syntax Q12 of 15

SQL - Views

Which of the following is the correct syntax to change the query inside an existing view named employee_view?

AMODIFY VIEW employee_view SELECT * FROM employees;

BUPDATE VIEW employee_view SET query = 'SELECT * FROM employees';

CALTER VIEW employee_view AS SELECT * FROM employees WHERE active = 1;

DCHANGE VIEW employee_view TO SELECT * FROM employees;

Step-by-Step Solution

Solution:

Step 1: Recall ALTER VIEW syntax
The correct syntax to change a view's query is ALTER VIEW view_name AS SELECT ....
Step 2: Check each option
ALTER VIEW employee_view AS SELECT * FROM employees WHERE active = 1; uses the correct syntax. Options B, C, and D use invalid or non-existent commands.
Final Answer:
ALTER VIEW employee_view AS SELECT * FROM employees WHERE active = 1; -> Option C
Quick Check:
ALTER VIEW uses AS SELECT [OK]

Quick Trick: Use ALTER VIEW view_name AS SELECT ... to update a view [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes