PostgreSQL Exam PGCES-02 Topic 10 Question 69 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 69
Topic #: 10

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;

A1 row

B2 rows

C3 rows

D4 rows

E0 rows

Show Suggested Answer

Suggested Answer: B

by Kathrine at Aug 22, 2024, 05:26 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Myra

7 months ago

I think the answer is E) 0 rows because of the ROLLBACK statement.

upvoted 0 times

...

Leonor

7 months ago

Wait, did they just throw in a COMMIT at the end to confuse us? I'm going with D) 4 rows, just to be on the safe side. Better safe than sorry, right?

upvoted 0 times

Wilford

6 months ago

I'm sticking with 4 rows just to play it safe.

upvoted 0 times

...

Fidelia

7 months ago

I'm sticking with 4 rows, just to be safe.

upvoted 0 times

...

Shizue

7 months ago

I agree, I'll go with 2 rows as well.

upvoted 0 times

...

Marshall

7 months ago

I'm not sure, maybe it's 0 rows because of the ROLLBACK.

upvoted 0 times

...

Lashawnda

7 months ago

But then the COMMIT should make it 3 rows, right?

upvoted 0 times

...

Oretha

7 months ago

I think it's 2 rows because of the ROLLBACK to the SAVEPOINT.

upvoted 0 times

...

Mitsue

7 months ago

I think it's actually 2 rows because of the ROLLBACK to the SAVEPOINT sp.

upvoted 0 times

...

Leonard

7 months ago

I'm not sure, but I think the answer might be D) 4 rows.

upvoted 0 times

...

Fanny

8 months ago

This is a tricky one, but I think I've got it. The ROLLBACK TO sp ensures that the 'B' row is never committed, so the final count is 2 rows. B) 2 rows is the way to go.

upvoted 0 times