You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

• A.Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
• B.Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.
• C.Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
• D.Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.
• E.Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

Comment: *

Name: *

Email: *

Verification: *

Exhibit:

What does the possible_keys column in this output denote?

• A.if there are any indexes that may be used to solve this query
• B.whether there are any indexes in your query
• C.whether there are any indexes on the tables that you are querying
• D.if it is possible for you to include any indexes in your query

Comment: *

Name: *

Email: *

Verification: *

You want to immediately stop access to a database server for remote user
'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)

• A.Execute the mysql_secure_installation command.
• B.Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;
• C.Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';
• D.Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;
• E.Use DROP USER `mike'@'client.example.com';
• F.Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;

Comment: *

Name: *

Email: *

Verification: *

Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

• A.to find out why a query takes a long time to execute on a given table
• B.to make sure a table has no structural problems
• C.to improve performance by updating index distributing statistics on InnoDB tables
• D.to repair table structure problem
• E.to make sure that no table indexes are corrupted

Comment: *

Name: *

Email: *

Verification: *

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

• A.The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.
• B.The `adam' user must have the SUPER privilege in order to take data backups.
• C.The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• D.The `adam' user must also have SELECT on the football database for backups to work.

Comment: *

Name: *

Email: *

Verification: *