Online Access Free 1Z0-888 Exam Questions

What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)

• A.The MySQL Query Cache is disabled.
• B.The hardware includes a single point of failure.
• C.OPTIMIZE TABLE is not executed for the InnoDB tables.
• D.A configuration change was made.
• E.Monitoring has not enabled all Performance Schema instruments.
• F.The application executes a new untested query.

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

• A.It results in a syntax error because you cannot specify more than one partition in the same statement.
• B.All data in p1 and p3 partitions is removed and the table definition is changed.
• C.Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
• D.All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.
Which three statements are true? (Choose three.)

• A.The sys.session view provides the process list with additional information.
• B.The threads table contains all the required columns.
• C.The events_statements_current consumer must be enabled.
• D.The PROCESS privilege is required.
• E.The performance impact is less than SHOW FULL PROCESSLIST.
• F.A connection must be instrumented to be included in the list of processes.

Which statement is correct about how InnoDB storage engine uses disk space?

• A.It stores its data, index and undo information in .MYD and .MYI files.
• B.It stores data in .MYD files, index information in .MYI files, and undo information in the common tablespace.
• C.It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.
• D.It stores data in .MYD files and its index and undo information in the common tablespace.
• E.It stores data, index and undo information in tablespace file(s).

How does the InnoDB storage engine handle deadlocks when they are detected?

• A.The transaction isolation level determines which transaction is rolled back.
• B.The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• C.The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
• D.One of the affected transactions will be rolled back, the other is allowed to proceed.
• E.Both the affected transactions will be rolled back.