nerdexam
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)
  • A
    4% (1)
  • B
    83% (20)
  • C
    4% (1)
  • E
    8% (2)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice