Which of the following is the correct syntax to create a view named SalesView showing product_id and quantity from Sales table?

easy📝 Syntax Q3 of 15

SQL - Views

Which of the following is the correct syntax to create a view named SalesView showing product_id and quantity from Sales table?

ACREATE VIEW SalesView AS SELECT product_id, quantity FROM Sales;

BCREATE SalesView VIEW AS SELECT product_id, quantity FROM Sales;

CVIEW CREATE SalesView AS SELECT product_id, quantity FROM Sales;

DCREATE VIEW SalesView SELECT product_id, quantity FROM Sales;

Step-by-Step Solution

Solution:

Step 1: Recall the correct CREATE VIEW syntax
The correct syntax is: CREATE VIEW view_name AS SELECT columns FROM table;
Step 2: Check each option against the syntax
CREATE VIEW SalesView AS SELECT product_id, quantity FROM Sales; matches the correct syntax exactly. Options A, C, and D have incorrect keyword order or missing AS keyword.
Final Answer:
CREATE VIEW SalesView AS SELECT product_id, quantity FROM Sales; -> Option A
Quick Check:
Correct CREATE VIEW syntax = CREATE VIEW SalesView AS SELECT product_id, quantity FROM Sales; [OK]

Quick Trick: CREATE VIEW view_name AS SELECT ... FROM ...; [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