A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

• A.SET GTID_NEXT="CONSISTENCY";
  BEGIN; COMMIT;
  SET GTID_NEXT="AUTOMATIC";
• B.SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";
• C.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
• D.SET GLOBAL enforce_gtid_consistency=ON
• E.SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

Comment: *

Name: *

Email: *

Verification: *

You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

• A.3304
• B.3303
• C.3301
• D.3302

Comment: *

Name: *

Email: *

Verification: *

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

• A.in the /var/lib/mysql/hostname.log file
• B.no logging enabled by default
• C.in the /var/log/mysqld.err file
• D.in the syslog daemon on the server

Comment: *

Name: *

Email: *

Verification: *

Consider the key buffer in a MySQL server. Which two statements are true about this feature?

• A.It caches index blocks for MyISAM tables only.
• B.It caches index blocks for all storage engine tables.
• C.It is a global buffer.
• D.It is set on a per-connection basis.
• E.It caches index blocks for InnoDB tables only.

Comment: *

Name: *

Email: *

Verification: *