Which statement best describes the purpose of the InnoDB buffer pool?

• A.It is amount of buffers available during a transaction.
• B.It caches only the indexes for InnoDB tables.
• C.It caches data and indexes for InnoDB tables.
• D.It holds changes made during a transaction before they are written to the log.
• E.It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Comment: *

Name: *

Email: *

Verification: *

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

• A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• C.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• D.Start the MySQL Server with -initialize-insecure to force a password reset procedure on the command line.
• E.Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

Comment: *

Name: *

Email: *

Verification: *

You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?

• A.InnoDB no longer automatically updates index statistics after a CREATE TABLE statement.
• B.InnoDB no longer automatically updates index statistics after the table structure is altered.
• C.InnoDB no longer automatically updates index statistics after 10% of the rows in a table change.
• D.InnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.

Comment: *

Name: *

Email: *

Verification: *

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

• A.The time the query took is the sum of all timer_wait values.
• B.The query did not find its table in the table definition cache.
• C.The event with event_id = 8945 is a child of the event with event_id=8944.
• D.The query read data from the data file rather than directly from the buffer pool.

Comment: *

Name: *

Email: *

Verification: *

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

• A.The User field is too long for most names.
• B.No indexes are defined.
• C.Date should be a TIMESTAMP field for better performance.
• D.The engine type is not appropriate to the application use.
• E.Using default values for DATETIME causes table scans.

Comment: *

Name: *

Email: *

Verification: *