PostgreSQL_CE
PGCES-02 · Question #86
PGCES-02 Question #86: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #86. The question stem and answer options stay visible for context.
Question
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; PostgreSQL CE PGCES-02 Exam 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".
Options
- AThe update process for client "B" is blocked until the current connection for client "A" is
- BThe update process for client "B" is blocked until the current transaction for client "A" is
- 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
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.