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;
- An error is generated at the point the SELECT statement is executed.
- An error is generated at the point the INSERT statement is executed.
- An error is generated at the point the UPDATE statement is executed.
- An error is generated at the point the DELETE statement is executed.
- No error is generated.
Reveal Solution
Next Question