Online Access Free 1Z0-888 Exam Questions

Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A.A full table scan is being used.
• B.No index has been defined on the filtered column.
• C.There are 108 queries still being executed.
• D.There is network congestion between client and server.
• E.A table lock is causing delays.

Which statement is true about tablespaces?

• A.General tablespaces can be configured to span multiple files.
• B.All tables must be in either the system tablespace or a general tablespace.
• C.The system tablespace can be configured to span multiple files.
• D.All tablespace files must be in the directory specified by the -datadir option.

At which stage during query processing does MySQL create a query's execution plan?

• A.Executing
• B.Parsing
• C.Authorizing
• D.Optimizing

A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

• A.--skip-opt
• B.--single-transaction
• C.--lock-all-tables
• D.--master-data
• E.--create-apply-log

What two statements are true regarding FLUSH TABLES FOR EXPORT?

• A.It is the safest way to extract tables from the shared tablespace.
• B.It can be used to export TEMPORARY tables.
• C.Partitioned tables are not supported.
• D.The InnoDB Storage engine must be used for the table being exported.
• E.Table only exports when the table has its own tablespace.