Examine this statement and output:

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

• A.QN = 5
• B.QN = 3
• C.QN = 4
• D.QN = 2
• E.QN = 1

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about MySQL replication? (Choose three.)

• A.A replication user must have the SELECT privilege for all tables that need to be replicated.
• B.Binary logs contain only transactions originating from a single MySQL instance.
• C.Each instance in a replication topology must have a unique server ID.
• D.Each slave must have its own MySQL user for replication.
• E.Any instance can have multiple slaves, but it can have only one master.
• F.Replication can use only TCP/IP connections.
• G.Binary logging must be enabled on the master in order to replicate to other instances.

Comment: *

Name: *

Email: *

Verification: *

Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

• A.kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
• B.mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
• C.kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
• D.kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

Comment: *

Name: *

Email: *

Verification: *

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

• A.They take roughly twice as long as logical backups.
• B.There is a slight performance cost while the snapshot is active.
• C.They work best for transaction storage engines that can perform their own recovery when restored.
• D.They do not back up views, stored procedures, or configuration files.
• E.They do not use additional disk space.
• F.They allow direct copying of table rows with operating system copy commands.
• G.The backup window is almost zero from the perspective of the application.

Comment: *

Name: *

Email: *

Verification: *

You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

• A.Remove ib_logfile0 and ib_logfile1 files from the file system.
• B.Execute mysqladmin flush-logs.
• C.Create a new ib_logfile0 file of size 26214400.
• D.First run mysqld --initialize to refresh the Size of ib_logfile.

Comment: *

Name: *

Email: *

Verification: *