PostgreSQL Exam PGCES-02 Topic 5 Question 45 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 45
Topic #: 5

Select two correct statements that describe what occurs on the client side when the following command is executed. pg_ctl -m smart stop

AClients will not be able to make new connections.

BThe running transaction for a connected client is rolled back and the connection is disconnected forcibly.

CConnections are terminated after the currently running transactions have finished.

DThe processes of currently connected clients are processed normally.

EConnected clients receive a message saying that the server will soon be shutdown.

Show Suggested Answer

Suggested Answer: A

by Carmela at Jul 09, 2023, 06:31 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Winfred

16 days ago

Okay, let's see... A and C seem the most likely to me. I'm picturing the server just sitting there, arms crossed, refusing new connections until the existing ones wrap up.

upvoted 0 times

...

Anastacia

17 days ago

Haha, I bet the exam writers just wanted to see if anyone would pick D 'cause it sounds hilarious. Like, 'Oh, the server's shutting down? Nah, we'll just keep on truckin'!'

upvoted 0 times

...

Ruthann

24 days ago

I'm not sure about E, does the server really send a message to connected clients? Seems like that's not mentioned in the command description.

upvoted 0 times

...

2 months ago

I think statement A is correct because clients won't be able to make new connections.

upvoted 0 times

...