Oracle
1Z0-888 · Question #87
1Z0-888 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
Installation and Configuration
Question
An employee cannot access the company database. You check the connection variables:
mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| connect_timeout | 10 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_connect_stats_allow_query_stats | OFF |
| max_connect_errors | 10 |
| max_connections | 50 |
| max_user_connections | 10 |
+--------------------+-------+
8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT ... TO 'bob'@'%.example.com' WITH MAX_USER_CONNECTIONS 0;
GRANT ... TO 'kay'@'%.example.com' WITH MAX_USER_CONNECTIONS 1;
GRANT ... TO 'joe'@'%.example.com' WITH MAX_USER_CONNECTIONS 10;
What is a valid for why one of the users is unable to connect to the database?
Options
- ABob has max_user_connections set to zero, which blocks all his connections.
- BAll users are blocked because max_user_connections is accumulated over the host account information.
- Cconnect_timeout is too small to allow a connection to occur.
- DJoe has exceeded the max_user_connections global limit.
- EKay is already connected elsewhere and attempting to log in again.
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
#max_user_connections#connection limits#user privileges#MySQL configuration