新问题 47
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

新问题 48
Which three sets of item information are visible in the mysql system database? (Choose three.)

新问题 49
You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

新问题 50
Examine this command and output:

哪两个说法是正确的？(请选择两项）。

新问题 51
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

新问题 52
Which two statements are true about MySQL server multi-source replication? (Choose two.)

新问题 53
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

新问题 54
Examine this query and output:

哪两个说法是正确的？(请选择两项）。

新问题 55
Which condition is true about the use of the hash join algorithm?

新问题 56
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377’’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

新问题 57
Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

新问题 58
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

新问题 59
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

哪种说法是正确的？

新问题 60
Examine this command and output:

哪种说法是正确的？

新问题 61
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

新问题 62
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

新问题 63
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

哪种说法是正确的？

新问题 64
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?

新问题 65
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

新问题 66
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?