Oracle
1Z0-888 · Question #90
1Z0-888 Question #90: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #90. The question stem and answer options stay visible for context.
Installation and Configuration
Question
To query two system variables, you execute this statement and get the results shown:
mysql> SELECT @@autocommit, @@max_connections;
+--------------+-------------------+
| @@autocommit | @@max_connections |
+--------------+-------------------+
| 1 | 151 |
+--------------+-------------------+
1 row in set (0.00 sec)
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
Options
- Amax_connections is a read-only variable that cannot be set dynamically.
- Bmax_connections must be set globally instead of locally.
- Cmax_connections is a derived variable that can only be set indirectly.
- Dmax_connections must be set at server start in an options file.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#system variables#dynamic configuration#static variables#MySQL configuration