PostgreSQL_CE
PGCES-02 · Question #83
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;
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
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
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.