A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

• A.mysql> SOURCE '/var/tmp/customers.sdi'
• B.shell> cp /backup/customers.frm /var/lib/mysql/shop/
• C.mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
• D.mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
• E.mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
• F.shell> cp /backup/customers.sdi /var/lib/mysql/shop/
• G.mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
• H.shell> cp /backup/customers.sdi /var/tmp

Comment: *

Name: *

Email: *

Verification: *

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

• A./var/lib/mysql
• B./usr
• C./usr/mysql
• D./etc/my.cnf
• E./usr/bin

Comment: *

Name: *

Email: *

Verification: *

Examine these commands and output:

Which connection ID is holding the metadata lock?

• A.24
• B.6
• C.22
• D.25
• E.21
• F.20

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B.RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C.RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
• D.RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E.RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Comment: *

Name: *

Email: *

Verification: *

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

• A.It defines all innodb tablespace options relative to a starting parent directory.
• B.It adds more temporary workspace in addition to the innodb_tmpdir location.
• C.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• D.It allows scanning of other locations to discover more innodb tablespaces.
• E.It is not necessary because innodb_data_home_dir is already defined.

Comment: *

Name: *

Email: *

Verification: *