An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

• A.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;
• B.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• C.STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D.STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

Comment: *

Name: *

Email: *

Verification: *

Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

• A.The selectivity of the dept_no column is the best of the indexed columns.
• B.There is a redundant index on the dept_no column.
• C.There is a redundant index on the emp_no column.
• D.There are three indexes on the table.
• E.The values on the emp_no column must be unique.
• F.The secondary indexes are optimized for unique key look-ups.

Comment: *

Name: *

Email: *

Verification: *

Suppose you are adding rows to a MyISAM table and the --datadirlocation runs out of disk space.
What will happen when this occurs?

• A.An error message will be returned to the client .Server Error: ER_IO
• B.The server suspends operations for all storage engines until space becomes available.
• C.The server suspends that INSERT operation until space becomes available.
• D.The server will crash.

Comment: *

Name: *

Email: *

Verification: *

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

• A.The dictionary file word list is too short.
• B.The dictionary file is in an insecure location.
• C.The validate_password plug-in has not been loaded.
• D.The name of the dictionary file is too obvious.
• E.validate_password_policy cannot be set without restarting the MySQL instance.
• F.validate_password_dictionary_file cannot be set without restarting the MySQL instance.

Comment: *

Name: *

Email: *

Verification: *

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

• A.The slave is configured with slave_parallel_workers = 4
• B.THREAD_ID 21 has stopped running.
• C.The server needs more cores to use all slave threads.
• D.At most, two schemas are being updates concurrently.
• E.The salve has two intermediate relay slaves connected to it.
• F.The slave cannot process the relay log fast enough to use all threads.

Comment: *

Name: *

Email: *

Verification: *