Which of the following is the correct syntax to create a view named employee_view showing all columns from employees table?

easy📝 Syntax Q12 of 15

SQL - Views

Which of the following is the correct syntax to create a view named employee_view showing all columns from employees table?

ACREATE employee_view VIEW AS SELECT * FROM employees;

BCREATE VIEW employee_view FROM employees;

CVIEW CREATE employee_view AS SELECT * FROM employees;

DCREATE VIEW employee_view AS SELECT * FROM employees;

Step-by-Step Solution

Solution:

Step 1: Recall the standard syntax for creating a view
The correct syntax is: CREATE VIEW view_name AS SELECT ...
Step 2: Match the syntax with options
CREATE VIEW employee_view AS SELECT * FROM employees; matches the correct syntax exactly.
Final Answer:
CREATE VIEW employee_view AS SELECT * FROM employees; -> Option D
Quick Check:
CREATE VIEW ... AS SELECT ... [OK]

Quick Trick: Use 'CREATE VIEW view_name AS SELECT ...' format [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