Question 1

How can we start MySQL when it was installed using RPM in Oracle Enterprise Linux 7?

Options :

A : mysqld_safe --user=mysql &

B : systemctl start mysqld

C : service start mysql

D : mysqladmin -u root start

Answer: B

Question 2

You have an InnoDB Cluster configured with three servers.Examine this command, which executes successfully:mysqldump -uroot -p -d mydatabase > mydatabase_backup.sqlDue to data loss, the cluster is initialized and a restore is attempted resulting in this error:ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin runningWhich two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Options :

A : Stop all instances except the primary read/write master instance and run the restore.

B : Remove the @@GLOBAL.gtid_purged statement from the dump file.

C : Create the backup by using the --set-gtid-purged=OFF option.

D : Remove the group replication plugin from each instance before restoring.

E : Remove the @@GLOBAL.gtid_executed statement from the dump file.

F : Restore using the --set-gtid-purged=OFF option.

Answer: B,C

Question 3

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.Examine the output: Other-Image-30e9b1e03-8bbc-4275-a4c0-1ac8f11994b9 What statement is true about the start attempt?

Options :

A : MySQL server was not started due to a problem while executing process 2732.

B : MySQL server continued to start up even though another process existed.

C : systemd found the mysqld service disabled and failed to start it.

D : systemd waited for 30 seconds before timing out and start up failed.

E : systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: A

Question 4

Examine this statement, which executes successfully: Other-Image-2d087695c-370a-4149-9dae-43fdb2993133 You want to improve the performance of this query: Other-Image-4d087695c-370a-4149-9dae-43fdb2993133 Which change enables the query to succeed while accessing fewer rows?

Options :

A : ALTER TABLE world.city ADD SPATIAL INDEX (Name);

B : ALTER TABLE world.city ADD SPATIAL INDEX (Population);

C : ALTER TABLE world.city ADD INDEX (Population);

D : ALTER TABLE world.city ADD INDEX (Name);

E : ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F : ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Answer: B

Question 5

Your MySQL environment has asynchronous position based-replication with one master and one slave.The slave instance had a disk I/O problem, so it was stopped.You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.You restart MySQL Server.How can replication be restored?

Options :

A : The slave relay logs should be deleted; then execute START SLAVE;

B : The relay logs from the master should be used to replace the corrupted relay logs.

C : The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : The slave needs to be restored from backup.

Answer: B