PostgreSQL PGCES-02 Exam - Topic 2 Question 3 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 3
Topic #: 2

Table "t1" is defined below. Table "t1" has a column "id" of type INTEGER, and a column "name" of type TEXT. t1: The following SQL is executed while client "A" is connected. BEGIN;

SELECT * FROM t1 WHERE id = 2 FOR UPDATE; SELECT * FROM t1 WHERE id = 1 FOR UPDATE; -- (*) While the second 'SELECT' statement, shown with (*), is being executed, a separate client "B" connects and executes the following SQL. Select the correct statement about the execution results. UPDATE t1 SET name = 'turtle' WHERE id = 2; Note: the default transaction isolation level is set to "read committed".

AThe update process for client 'B' is blocked until the current connection for client 'A' is finished.

BThe update process for client 'B' is blocked until the current transaction for client 'A' is finished.

CThe 'UPDATE' process for client 'B' proceeds regardless of the condition of client 'A'.

DThe process of client 'B' immediately generates an error.

EThe processes for both clients are blocked, and an error stating that a deadlock has been detected is generated.

Show Suggested Answer

Suggested Answer: B

by Janine at May 09, 2022, 02:01 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Caitlin

6 months ago

E sounds like a stretch, deadlock isn't happening here.

upvoted 0 times

...

Isabella

6 months ago

I think C is wrong, B can't just proceed like that.

upvoted 0 times

...

Sharan

6 months ago

Wait, does that mean B can't update anything at all?

upvoted 0 times

...

Isadora

7 months ago

Totally agree, B will be blocked until A finishes.

upvoted 0 times

...

Meghann

7 months ago

Client A's transaction locks the row for id 2.

upvoted 0 times

...

Edna

7 months ago

I recall something about deadlocks, but I don't think that's happening here since client 'B' is just waiting on client 'A'.

upvoted 0 times

...

Gabriele

7 months ago

I'm not entirely sure, but I feel like client 'B' should be able to proceed since it's not trying to update the same row as client 'A'.

upvoted 0 times

...

Therese

7 months ago

I think the update from client 'B' might be blocked because client 'A' has a lock on the row with id = 2.

upvoted 0 times

...

Princess

7 months ago

I remember practicing a similar question where one transaction had to wait for another to finish. I think that applies here too.

upvoted 0 times

...

Levi

7 months ago

I'm pretty sure web spiders are used for indexing websites, so I'll go with option A.

upvoted 0 times

...

Yuette

7 months ago

This is a good test of my understanding of the cost of quality. I'll carefully consider each option and try to apply the definition I know to determine the best answer.

upvoted 0 times

...

Sylvia

7 months ago

I'm a bit unsure about this one. I want to make sure I'm not missing any details in the question.

upvoted 0 times

...