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

Which additional argument makes this operation safer?

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

Comment: *

Name: *

Email: *

Verification: *

This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

• A.The master has performed a large transaction, which will take 360 seconds to complete on the slave.
• B.The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
• C.The slave was configured for delayed replication with a delay of six minutes.
• D.The network latency between the master and the slave is 360 milliseconds.

Comment: *

Name: *

Email: *

Verification: *

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysqlsystem database are missing. Which step do you perform to create the contents of the data directory?

• A.Run the create_system_tables.sqlfile
• B.Run the mysql_unpack.sqlfile
• C.Invoke mysqldwith the --initializeoption.
• D.Invoke mysqlwith the --initializeoption.

Comment: *

Name: *

Email: *

Verification: *

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

• A.--tab
• B.--skip-buffer
• C.--quick
• D.--single-transaction

Comment: *

Name: *

Email: *

Verification: *

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

• A.All these tables have the same number of rows.
• B.The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.
• C.The session_statustable is equivalent to status_by_threadfor the current thread.
• D.The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.
• E.The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.

Comment: *

Name: *

Email: *

Verification: *