Exam 1z0-908 topic 1 question 103 discussion

Actual exam question from Oracle's 1z0-908

Question #: 103
Topic #: 1

The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

A. The minimum value increases to 3000 and the maximum value increases to 4000.
B. Only the minimum connection value is increased to 3000.
C. The minimum connection value is changed to 2000.
D. An error is returned.

Show Suggested Answer

Suggested Answer: D 🗳️

by Dhanushka at Aug. 2, 2023, 9:10 a.m.

Comments

Submit Cancel

FelipeK

2 months, 1 week ago

Selected Answer: D

root@localhost[(none)]> show variables like '%connection_control_max_connection_delay%'; +-----------------------------------------+-------+ | Variable_name | Value | +-----------------------------------------+-------+ | connection_control_max_connection_delay | 2000 | +-----------------------------------------+-------+ 1 row in set (0.00 sec) root@localhost[(none)]> SET GLOBAL connection_control_min_connection_delay=3000; ERROR 1231 (42000): Variable 'connection_control_min_connection_delay' can't be set to the value of '3000'

upvoted 2 times

...

Dhanushka

5 months, 1 week ago

Selected Answer: D

First Max value need to change

upvoted 2 times

...

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Exam 1z0-908 topic 1 question 103 discussion

Comments

FelipeK

Dhanushka

SY0-701