You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

• A.Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-formatvalue set to STATEMENT.
• B.The changes caused by the UPDATEstatement are logged to the binary log because the instance is using
  --binlog-format = ROW
• C.Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
• D.The statement would fail because you cannot update more than one row at a time when using --binlog- format = ROW.
• E.You would receive an error on the statement because you cannot update a different database that what is specified with the USEstatement.

Comment: *

Name: *

Email: *

Verification: *

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

What would you run to fix the issue?

• A.the mysql_upgrade script
• B.the mysql client with the --ignore-password-hashing option
• C.the mysql_secure_installation script to update server security settings
• D.the mysql client with the --enable-cleartext-plugin option
• E.the install plugin command for the mysql_cleartext_password plugin

Comment: *

Name: *

Email: *

Verification: *

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• A.it contains the binary log.
• B.it contains a general tablespace.
• C.it is the default location for all new tables that you create.
• D.it contains the system tablespace.
• E.it contains the redo log.
• F.it contains the undo log.

Comment: *

Name: *

Email: *

Verification: *

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

Which additional argument makes this operation safer?

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

Comment: *

Name: *

Email: *

Verification: *

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *