nerdexam
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)
  • A
    3% (1)
  • B
    83% (24)
  • C
    10% (3)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice