Oracle
1Z0-883 · Question #44
An employee cannot access the company database. You check the connection variables: Mysql> SHOW GLOBAL VARIABLES LIKE %connect%'; 8 rows in set (0.00 sec) A look at the user privileges shows…
The correct answer is D. Kay is already connected elsewhere and attempting to log in again. See the full explanation below for the reasoning.
Question
An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE `%connect%'; 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 key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO `joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?
Exhibit
Options
- ABob has max_user_connections set to zero, which blocks all his connections
- BJoe has exceeded the max_user_connections global limit.
- CAll users are blocked because max_user_connections is accumulated over the host account information.
- DKay is already connected elsewhere and attempting to log in again.
- EConnect_timeout is too small to allow a connection to occur.
How the community answered
(52 responses)- A10% (5)
- B2% (1)
- C4% (2)
- D83% (43)
- E2% (1)
Community Discussion
No community discussion yet for this question.