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

Contribute your Thoughts:

Submit Cancel

10 days ago

I'm not sure about statement E. I think it's actually A and C that are correct.

upvoted 0 times

...

12 days ago

I agree with Raina. When the server is stopped with pg_ctl -m smart, the running transaction is rolled back and clients receive a shutdown message.

upvoted 0 times

...

16 days ago

I think the correct statements are B and E.

upvoted 0 times

...

17 days ago

But what about statement C? Connections are terminated after running transactions finish, right?

upvoted 0 times

...

19 days ago

I agree with statement E, connected clients receive a message about the server shutdown.

upvoted 0 times

...

25 days ago

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

upvoted 0 times

...