Online Access Free 1z1-883 Exam Questions

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?

• A.Kay is already connected elsewhere and attempting to log in again.
• B.Joe has exceeded the max_user_connections global limit.
• C.Connect_timeout is too small to allow a connection to occur.
• D.Bob has max_user_connections set to zero, which blocks all his connections
• E.All users are blocked because max_user_connections is accumulated over the host account information.

You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' connot be loaded: plugin not enabled
What would you run to fix the issue?

• A.The mysql client with the - ignore-password-hashing option
• B.The install plugin command for the mysql_cleartext_password plugin
• C.The mysql client with the - enable-cleartext-plugin option
• D.The mysql_upgrade script
• E.The mysql_secure_installation script to update server security settings

Which two requirements would lead towards a high availability solution?

• A.When data loss is unacceptable
• B.When application is a single point of failure
• C.When uptime is critical
• D.When application concurrency is static
• E.When data must be refactored

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

• A.RAID 5
• B.NFS (Networked File System)
• C.SAN (Storage Area Network)
• D.iSCSI

ROW-based replication has stopped working. You investigate the error log file and find the following entries:
2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error
HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032
2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032
2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684
Why did you receive this error?

• A.Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
• B.The table definition on the slave -litters from the master.
• C.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
• D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.