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

2 months 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

2 months 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

Margarita

19 days ago

E) Connected clients receive a message saying that the server will soon be shutdown.

upvoted 0 times

...

Levi

28 days ago

B) The running transaction for a connected client is rolled back and the connection is disconnected forcibly.

upvoted 0 times

...

Shenika

2 months ago

A) Clients will not be able to make new connections.

upvoted 0 times

...

Ruthann

2 months 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

Donette

1 months ago

C) Connections are terminated after the currently running transactions have finished.

upvoted 0 times

...

Monte

1 months ago

A) Clients will not be able to make new connections.

upvoted 0 times

...

Pedro

2 months ago

I think the correct answers are B and C. The command will stop the server in a 'smart' mode, which means that it'll wait for current transactions to finish before disconnecting clients.

upvoted 0 times