1Z1-888 무료 덤프문제 온라인 액세스

Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A.Logical backups are always larger than physical backups.
• B.Physical backups can be used to recover from data corruption.
• C.Logical backups are human-readable whereas physical backups are not.
• D.Physical backups are usually slower than text backups.
• E.Physical backups are usually faster than text backups.

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

• A.The dictionary file word list is too short.
• B.The validate_password plug-in has not been loaded.
• C.The dictionary file is an insecure location.
• D.validate_password_policy cannot be set without restarting the MySQL instance.
• E.validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• F.The name of the dictionary file is too obvious.

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

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 was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
• B.The statement would fail because you cannot update more than one row at a time when using ?
  binlogformat = ROW.
• C.You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
• D.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-format value set to STATEMENT.
• E.The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

The Performance Schema includes these tables related to status variables:

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

• A.The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.
• B.All these tables have the same number of rows.
• 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 global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.

A crucial database, `db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?

• A.validating all user input before sending it to the database server
• B.using a hashing or encryption method to secure all user passwords in your MySQL tables
• C.giving limited privileges to accounts used by application servers to interact with their backing databases
• D.writing your client code to properly escape all user input
• E.removing any remaining anonymous accounts from your MySQL instance
• F.changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password
• G.using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions