You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

• A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• C.Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
• D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• E.Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

Comment: *

Name: *

Email: *

Verification: *

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

• A.log-master-updates
• B.rpl-recovery-rank
• C.server-id
• D.enable-master-start
• E.log_bin
• F.master-logging

Comment: *

Name: *

Email: *

Verification: *

You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

• A.shell> mysqladmin recover test dump.sql
• B.shell> mysql test < dump.sql
• C.shell> mysqlimport test dump.sql
• D.mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';
• E.mysql>USE test; mysql>SOURCE dump.sql;

Comment: *

Name: *

Email: *

Verification: *

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

• A.mysqld_safe
• B.mysql_config_editor
• C.mysqladmin
• D.mysqlpasswd

Comment: *

Name: *

Email: *

Verification: *

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

• A.connect_timeout is too small to allow a connection to occur.
• B.All users are blocked because max_user_connectionsis accumulated over the host account information.
• C.Kay is already connected elsewhere and attempting to log in again.
• D.Joe has exceeded the max_user_connectionsglobal limit.
• E.Bob has max_user_connectionsset to zero, which blocks all his connections.

Comment: *

Name: *

Email: *

Verification: *