PostgreSQL_CE
PGCES-02 · Question #125
PGCES-02 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
There is a table "tb1" that has a column "c1" defined as type TEXT. The following SQL is executed while client "A" is connected. BEGIN; LOCK TABLE tb1 IN ACCESS EXCLUSIVE MODE; SELECT * FROM tb1; While the above 'SELECT' statement is being executed, client "B" connects to the same database and executes the following SQL. Select two correct statements describing the behavior of PostgreSQL. INSERT INTO tb1 (c1) VALUES ('new line'); Note: the default transaction isolation level is set to "read committed".
Options
- AThe process for client "B" is blocked until the current connection for client "A" is finished.
- BThe process for client "B" is blocked until the current transaction for client "A" is finished.
- CThe process for client "B" will be deleted regardless of the condition of client "A".
- DThe process of client"B" will affect the SELECT result of client "A".
- EThe process of client"B" will not affect the SELECT result of client "A".
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.