PostgreSQL CE PGCES-02 Exam A table and view are defined as follows: CREATE TABLE item (id INT, name TEXT, description TEXT); CREATE VIEW item_simple AS SELECT id, name FROM item; A set of SQL…

PostgreSQL CE PGCES-02 Exam A table and view are defined as follows:

CREATE TABLE item (id INT, name TEXT, description TEXT); CREATE VIEW item_simple AS SELECT id, name FROM item; A set of SQL statements were executed in the order below. Select the most appropriate statement concerning the execution results. BEGIN; SELECT * FROM item_simple; INSERT INTO item_simple VALUES (1, 'item_name_1'); UPDATE item_simple SET name = 'item_name_2' WHERE id = 1; DELETE FROM item_simple; END;