[Solved] Which SQL statement correctly modifies the definition of an existing view named sales_summary? — Ans: ALTER VIEW sales_summary AS SELECT * FROM sales WHERE amount > 1000; | SQL

SQL - Views

Which SQL statement correctly modifies the definition of an existing view named sales_summary?

AALTER VIEW sales_summary AS SELECT * FROM sales WHERE amount > 1000;

BUPDATE VIEW sales_summary SET query = 'SELECT * FROM sales';

CMODIFY VIEW sales_summary AS SELECT * FROM sales;

DREPLACE VIEW sales_summary AS SELECT * FROM sales WHERE amount > 1000;

Step-by-Step Solution

Solution:

Step 1: Identify correct syntax to change a view
Standard SQL uses ALTER VIEW to redefine a view's query.
Step 2: Check each option's validity
ALTER VIEW sales_summary AS SELECT * FROM sales WHERE amount > 1000; uses ALTER VIEW with a new SELECT statement, which is correct. Other options use invalid or unsupported syntax.
Final Answer:
ALTER VIEW sales_summary AS SELECT * FROM sales WHERE amount > 1000; -> Option A
Quick Check:
ALTER VIEW changes view definition = A [OK]

Quick Trick: Use ALTER VIEW with AS and new SELECT to change a view [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which SQL statement correctly modifies the definition of an existing view named sales_summary?