mediumSQLtransactions BEGIN COMMITSingle-choice MCQ
You issue several DDL and DML statements wrapped in BEGIN ... COMMIT in PostgreSQL, including a CREATE TABLE. Midway you ROLLBACK. What happens to the CREATE TABLE?
BEGIN;
CREATE TABLE staging (id int);
INSERT INTO staging VALUES (1);
ROLLBACK;
