Oracle
1Z0-883 · Question #44
1Z0-883 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 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.