You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

• A.include-master-info
• B.master-data
• C.master-binlog
• D.include-log-file

Comment: *

Name: *

Email: *

Verification: *

Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

• A.There are 510 connections to MySQL at the time of the output.
• B.There are 140 Performance Schema threads at the time of the output.
• C.There are more connections being idle than executing queries.
• D.All max_connectionswere in use at 2018-03-22 14:54:06
• E.The thread cache has been configured with thread_cache_sizeset to at least 6.

Comment: *

Name: *

Email: *

Verification: *

How does the InnoDB storage engine handle deadlocks when they are detected?

• A.Both the affected transactions will be rolled back.
• B.The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• C.One of the affected transactions will be rolled back, the other is allowed to proceed.
• D.The transaction isolation level determines which transaction is rolled back.
• E.The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Comment: *

Name: *

Email: *

Verification: *

Consider:

What does the range value in the type column mean?

• A.This type of index uses the range hash.
• B.There is a range of indexes that can be used.
• C.The table will be scanned over a certain range of values.
• D.You can use an index and return rows that fall within a range of values.

Comment: *

Name: *

Email: *

Verification: *