PostgreSQL_CE
PGCES-02 · Question #80
Table "t1" is defined as follows: PostgreSQL CE PGCES-02 Exam CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order.Select thenumber of rows that table…
The correct answer is B. 2 rows. See the full explanation below for the reasoning.
Question
Table "t1" is defined as follows:
PostgreSQL CE PGCES-02 Exam CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order.Select thenumber of rows that table "t1" has after execution. BEGIN; INSERT INTO t1 VALUES ('AA'); SAVEPOINT point1; INSERT INTO t1 VALUES ('BB'); SAVEPOINT point2; INSERT INTO t1 VALUES ('CC'); ROLLBACK TO point1; INSERT INTO t1 VALUES ('DD'); END;
Options
- A1 row
- B2 rows
- C3 rows
- D4 rows
- E0 rows
How the community answered
(29 responses)- A3% (1)
- B83% (24)
- C10% (3)
- E3% (1)
Community Discussion
No community discussion yet for this question.