Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

• A.executing REVOKE LOAD FROM *.*
• B.setting the --local-infile=0 option when starting mysqld
• C.executing REVOKE FILE ON *_* FROM ` `@'%'
• D.executing REVOKE FILE FROM *_*
• E.setting the --open-files-limit=0 option when starting mysqld
• F.setting the --local-service=0 option when starting mysqld

Comment: *

Name: *

Email: *

Verification: *

Consider:

Which statement best describes the meaning of the values in the ref columns?

• A.world.City.CountryCodeis used as the primary key for the Country table.
• B.world.City.CountryCode is used to sort the rows in the Citytable.
• C.No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.
• D.No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

Comment: *

Name: *

Email: *

Verification: *

What is the best method for monitoring Group Replication conflict resolution?

• A.the PERFORMANCE_SCHEMAtables
• B.the SHOW PROCESSLISTcommand
• C.the INNODBLock Monitor details
• D.the SHOW STATUScommand
• E.the INFORMATION_SCHEMAtables

Comment: *

Name: *

Email: *

Verification: *

You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:

What would you run to fix the issue?

• A.the mysql_upgradescript
• B.the mysqlclient with the --ignore-password-hashingoption
• C.the mysql_secure_installationscript to update server security settings
• D.the mysqlclient with the --enable-cleartext-pluginoption
• E.the install plugincommand for the mysql_cleartext_passwordplugin

Comment: *

Name: *

Email: *

Verification: *

You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

• A.--reset-grant-tables, to start the server with only the mysql database accessible.
• B.--skip-networking, to prohibit access from remote locations
• C.--read-only, to set all data to read-only except for super users
• D.--old-passwords, to start MySQL to use the old password format while running without the grant tables.

Comment: *

Name: *

Email: *

Verification: *