MENU
Select two correct statements that describe what occurs on the client side when the following command is executed. pg_ctl -m smart stop
Suggested Answer: A
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
32 comments · newest first
CA
Carylon
11 months ago
Wait, are you sure about D? That sounds off.
TH
Theresia
11 months ago
E is a nice touch, clients get a heads up.
WY
Wynell
11 months ago
I thought B was correct, but I guess not!
LA
Lai
11 months ago
C makes sense too, transactions finish before termination.
CE
Cecily
12 months ago
A is definitely true, no new connections allowed.
RE
Reiko
12 months ago
I vaguely recall E being a possibility too, as clients usually get notified before a shutdown, right?
EL
Eloisa
12 months ago
I feel like C is definitely right since it mentions that connections are terminated after transactions finish, which sounds familiar.
SE
Selma
1 year ago
I'm not sure about B; I remember something about transactions being rolled back, but I thought they would finish first.
LI
Lisbeth
1 year ago
I think option A is correct because clients shouldn't be able to connect while the server is shutting down.
WE
Weldon
1 year ago
Okay, let's see. The key benefits of denormalized data structures are reducing the amount of data processed and increasing query speed, right? I'm pretty confident those are two of the main advantages.
SH
Shayne
1 year ago
Okay, let me think this through step-by-step. The question is asking how to indicate to the browser that the cookie data should be sent over a secure connection. Option A mentions calling a getSecure() method, which sounds promising. I'll have to double-check the servlet API documentation to be sure.
CO
Cordelia
1 year ago
I think it's AnyConnect for the posture agent, but I'm a bit confused about the other option. Could it be related to PEAP or something?
TI
Tiera
1 year ago
I remember discussing how security testing might require specialized skills but I'm not sure if that means it's solely for security experts.
HO
Hoa
1 year ago
This seems like a straightforward question about the testing process. I'll need to think through the different test environments and where the units would be tested after integration.
WI
Winfred
1 year 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.
AN
Anastacia
1 year 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'!'
MA
Margarita
1 year ago
E) Connected clients receive a message saying that the server will soon be shutdown.
LE
Levi
1 year ago
B) The running transaction for a connected client is rolled back and the connection is disconnected forcibly.
SH
Shenika
1 year ago
A) Clients will not be able to make new connections.
RU
Ruthann
1 year 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.
DO
Donette
1 year ago
C) Connections are terminated after the currently running transactions have finished.
MO
Monte
1 year ago
A) Clients will not be able to make new connections.
PE
Pedro
1 year 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.
KA
Kattie
1 year ago
That's correct. Clients will not be able to make new connections and the server will shutdown after current transactions are done.
AR
Art
1 year ago
Yes, you're right. The running transaction is rolled back and connections are terminated after transactions finish.
AL
Alline
1 year ago
I think the correct answers are B and C.
SH
Shaun
1 year ago
I'm not sure about statement E. I think it's actually A and C that are correct.
ED
Edwin
1 year 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.
RA
Raina
2 years ago
I think the correct statements are B and E.
SH
Shawnee
2 years ago
But what about statement C? Connections are terminated after running transactions finish, right?
LA
Lashon
2 years ago
I agree with statement E, connected clients receive a message about the server shutdown.
SH
Shawnee
2 years ago
I think statement A is correct because clients won't be able to make new connections.