Which two statements describe how InnoDB recovery works?

• A.It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
• B.It is recommended to set innodb_force_recovery = 1 as part of normal operations.
• C.InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
• D.There will in general be lost committed transactions after a crash using the default settings.
• E.It is always required to enable innodb_force_recovery to perform a crash recovery.
• F.InnoDB handles most crash recoveries automatically.

Comment: *

Name: *

Email: *

Verification: *

Which two statements can be used to adjust the sort_buffer_size variable on a running MySQL server?
(Choose two.)

• A.mysql> SET GLOBAL sort_buffer_size=256000;
• B.mysql> SET SESSION sort_buffer_size=256000;
• C.mysql> CONF T; do global sort_buffer_size=256000;
• D.mysql> system sort_buffer_size=256000;
• E.mysql> SET VARIABLE sort_buffer_size=256000;

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

• A.Use the limit clause in conjunction with the order 3Y clause.
• B.Use the limit clause to limit the deletion to 100.000 rows.
• C.If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
• D.Change the replication mode to mixed before issuing any delete statements when the limit clause is used.

Comment: *

Name: *

Email: *

Verification: *

What is the order of tables shown in an EXPLAIN output?

• A.It lists tables from the smallest to the largest.
• B.It lists tables in the order in which their data will be read.
• C.It lists tables from the most optimized to the least optimized.
• D.It lists tables in the order in which they are specified in the statement that is being explained.

Comment: *

Name: *

Email: *

Verification: *