Which of the following is the correct syntax to create a simple updatable view on a single table employees showing id and name columns?

easy📝 Syntax Q12 of 15

PostgreSQL - Views and Materialized Views

Which of the following is the correct syntax to create a simple updatable view on a single table employees showing id and name columns?

ACREATE VIEW emp_view AS SELECT id, name FROM employees;

BCREATE VIEW emp_view AS UPDATE employees SET name = 'John';

CCREATE TABLE emp_view AS SELECT id, name FROM employees;

DCREATE FUNCTION emp_view() RETURNS TABLE(id INT, name TEXT) AS $$ SELECT id, name FROM employees; $$ LANGUAGE SQL;

Step-by-Step Solution

Solution:

Step 1: Recall the syntax to create a view
The syntax is CREATE VIEW view_name AS SELECT columns FROM table;
Step 2: Check each option
CREATE VIEW emp_view AS SELECT id, name FROM employees; matches the correct syntax for a simple view. The other options are incorrect because they use UPDATE, CREATE TABLE, or FUNCTION instead of CREATE VIEW.
Final Answer:
CREATE VIEW emp_view AS SELECT id, name FROM employees; -> Option A
Quick Check:
CREATE VIEW uses SELECT query [OK]

Quick Trick: CREATE VIEW uses SELECT, not UPDATE or TABLE [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free