PostgreSQL_CE
PGCES-02 · Question #83
PGCES-02 Question #83: Real Exam Question with Answer & Explanation
The correct answer is B. At the point that 'COMMIT' is executed, a message that starts with "Asynchronous notification. See the full explanation below for the reasoning.
Question
PostgreSQL CE PGCES-02 Exam The following SQL statements were executed using psql. Select the appropriate statement about the result. LISTEN sign_v; BEGIN; NOTIFY sign_v; COMMIT; LISTEN sign_v;
Options
- AAt the point that 'NOTIFY sign_v' is executed, a message that starts with "Asynchronous
- BAt the point that 'COMMIT' is executed, a message that starts with "Asynchronous notification
- CAt the point that 'SELECT * FROM pg_user;" is executed, a message that starts with
- DWhen 'LISTEN sign_v' is executed for the second time, a message that starts with
- EThe message "Asynchronous notification 'sign_v' received" is not received while in this
Community Discussion
No community discussion yet for this question.