Which of the following is the correct syntax to create a view named CustomerView showing id and name from the Customers table?

easy📝 Syntax Q3 of 15

SQL - Views

Which of the following is the correct syntax to create a view named CustomerView showing id and name from the Customers table?

ACREATE TABLE CustomerView AS SELECT id, name FROM Customers;

BMAKE VIEW CustomerView SELECT id, name FROM Customers;

CCREATE VIEW CustomerView AS SELECT id, name FROM Customers;

DVIEW CREATE CustomerView AS SELECT id, name FROM Customers;

Step-by-Step Solution

Solution:

Step 1: Recall the correct syntax for creating a view
The correct syntax starts with CREATE VIEW, followed by the view name, AS, and the SELECT query.
Step 2: Check each option
Only CREATE VIEW CustomerView AS SELECT id, name FROM Customers; matches the correct syntax exactly.
Final Answer:
CREATE VIEW CustomerView AS SELECT id, name FROM Customers; -> Option C
Quick Check:
Correct view syntax = CREATE VIEW CustomerView AS SELECT id, name FROM Customers; [OK]

Quick Trick: Use CREATE VIEW ... AS SELECT ... to define views [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