Online Access Free 1z0-883 Exam Questions

What are three actions performed by the mysql_secure_installation tool?

• A.It prompts you to set the root user account password.
• B.It asks to remove the test database, which is generated at installation time.
• C.It verifies that all users are configuration with the longer password hash.
• D.It checks whether file permissions are appropriate within datadir.
• E.It can delete any anonymous accounts.

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

• A.The command prints all parameter for the login-path. The password is replaced with stars.
• B.The command prints all parameters for the login-path. The password is shown only when you provide the -password option.
• C.The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
• D.The command prints all parameters for the login-path. The password is printed in plain text.

You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

• A.The server was not started with the - enable--ssl-plugin option.
• B.-- ssl is not a valid server option.
• C.The mysqld binary was not compiled with SSL support.
• D.The server's SSL certificate was invalid.
• E.The --- ssl level was not specified.

Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?

• A.Check the command-line options provided for the Mysql Server and compare them with default values.
• B.Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
• C.Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
• D.Check the output of SHOW GLOBAL VARIABLES and compare it with default values.

Identify a performance impact when using the Performance Schema.

• A.There is an overhead for querying the Performance Schema but not for having it enabled.
• B.The overhead depends on the settings of the Performance Schema.
• C.There is no impact on performance.
• D.There is a constant overhead regardless of settings and workload.