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

• A.MyISAM
• B.NDB
• C.MEMORY
• D.ARCHIVE
• E.InnoDB

Comment: *

Name: *

Email: *

Verification: *

Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

• A.All statements execute without error.
• B.Connection 24 experiences a lock wait timeout.
• C.Connection 25 experiences a lock wait timeout.
• D.A deadlock occurs after innodb_lock_wait_timeout seconds.
• E.A deadlock occurs immediately.

Comment: *

Name: *

Email: *

Verification: *

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnfparameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

• A.systemdattempted to start mysqld, found another systemd mysqldprocess running, and shut it down.
• B.MySQL server continued to start up even though another process existed.
• C.systemdwaited for 30 seconds before timing out and start up failed.
• D.systemd found the mysqldservice disabled and failed to start it.
• E.MySQL server was not started due to a problem while executing process 2732.

Comment: *

Name: *

Email: *

Verification: *

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

• A.It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
• B.It only starts all InnoDB Cluster instances.
• C.It is not mandatory that all instances are running and reachable before running the command.
• D.It stops and restarts all InnoDB Cluster instances and initializes the metadata.
• E.It only stops and restarts all InnoDB Cluster instances.
• F.It reconfigures InnoDB Cluster if the cluster was stopped.
• G.It performs InnoDB Cluster instances rolling restart.

Comment: *

Name: *

Email: *

Verification: *

An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

• A.Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency
• B.Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• C.On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• D.Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
• E.On the slave, alter the MySQL master connection setting with:
  ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• F.Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;

Comment: *

Name: *

Email: *

Verification: *