PostgreSQL_CE
PGCES-02 · Question #140
Table t1 is defined as follows: CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order. Select the number of rows that table "t1" has after execution…
The correct answer is B. 2 rows. See the full explanation below for the reasoning.
Question
Table t1 is defined as follows:
CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order. Select the number of rows that table "t1" has after execution. BEGIN; INSERT INTO t1 VALUES ('A'); SAVEPOINT sp; INSERT INTO t1 VALUES ('B'); ROLLBACK TO sp; INSERT INTO t1 VALUES ('C'); COMMIT;
Options
- A1 row
- B2 rows
- C3 rows
- D4 rows
- E0 rows
How the community answered
(24 responses)- A4% (1)
- B83% (20)
- C4% (1)
- E8% (2)
Community Discussion
No community discussion yet for this question.