PostgreSQL_CE
PGCES-02 · Question #80
PGCES-02 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
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
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.