Which SQL syntax correctly creates a simple updatable view on a single table employees showing id and name?

easy📝 Syntax Q12 of 15

SQL - Views

Which SQL syntax correctly creates a simple updatable view on a single table employees showing id and name?

ACREATE VIEW emp_view AS SELECT id, name FROM employees GROUP BY id;

BCREATE VIEW emp_view AS SELECT id, name, COUNT(*) FROM employees;

CCREATE VIEW emp_view AS SELECT id, name FROM employees;

DCREATE VIEW emp_view AS SELECT id, name FROM employees JOIN departments ON employees.dept_id = departments.id;

Step-by-Step Solution

Solution:

Step 1: Identify simple view syntax
CREATE VIEW emp_view AS SELECT id, name FROM employees; selects columns directly from one table without grouping or joins, which is valid for an updatable view.
Step 2: Check other options for complexity
Options A and C use GROUP BY or aggregate functions, making views non-updatable. CREATE VIEW emp_view AS SELECT id, name FROM employees JOIN departments ON employees.dept_id = departments.id; uses JOIN, also usually non-updatable.
Final Answer:
CREATE VIEW emp_view AS SELECT id, name FROM employees; -> Option C
Quick Check:
Simple select from one table = updatable view syntax [OK]

Quick Trick: Simple SELECT without joins or aggregates creates updatable 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