Consider the following statement on a RANGE partitioned table:

ALTER TABLE orders DROP PARTITION p1, p3;

What is the outcome of executing the above statement?

A. Only the first partition (p1) will be dropped as only one can be dropped at any time.

B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged.

C. A syntax error will result as you cannot specify more than one partition in the same statement.

D. All data in pi and p3 partitions are removed and the table definition is changed.

A database exists as a read-intensive server that is operating with query_cachek_type = DEMAND.

The database is refreshed periodically, but the resultset size of the queries does not fluctuate.

Note the following details about this environment:

A web application uses a limited set of queries.

The Query Cache hit rate is high.

All resultsets fit into the Query Cache.

All queries are configured to use the Query Cache successfully.

The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.

Based solely on the information provided, what is the most likely cause for this slowdown at the database level?

A. The Query Cache is pruning queries due to an increased number of requests.

B. Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups.

C. Mutex contention on the Query Cache is forcing the queries to take longer due to its single- threaded nature.

D. The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution.

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?

A. Ensure that none of the attached slaves are using any of the binary logs you want to delete.

B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

C. Execute the PURGE BINARY LOGE NOT USED command.

D. Remove all of the binary log files that have a modification date earlier than today.

E. Edit the .index file to remove the files you want to delete.

Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?

A. Mysql Replication

B. Distributed Replicated Block Device (DRBD) and Mysql

C. Windows Cluster and Mysql

D. Solaris Cluster and Mysql

E. Mysql NDB Cluster

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

A. shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C. shell> mysqlbinlog restore bin.00010 bin.00011 bin.00012

D. shell> mysqlbinlog include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

A. Mysqld uses internal configuration versioning and reverts to the previous configuration.

B. When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C. The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D. Mysqld prints to the error log about an unknown variable, and then exits.

A user executes the statement;

PURGE BINARY LOGS TO `mysql-bin.010';

What is the result?

A. It deletes all binary log files, except `mysql-in.010'.

B. It deletes all binary log files up to and including `mysql-bin.010'.

C. It deletes all binary log files before `mysql-bin.010'.

D. It deletes all binary log files after `mysql-bin.010'.

Which two capabilities are granted with the SUPER privilege?

A. Allowing a client to kill other client connections

B. Allowing a client to shut down the server

C. Allowing change of the server runtime configuration

D. Allowing client accounts to take over the account of another user

Consider the MySQL Enterprise Audit plugin,

You add the following lines to the my.cnf configuration tile:

[mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT

You attempt to start up the MySQL service and notice that it fails to start.

Which two statements would explain why the service did not start?

A. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

B. The audit_log.so library does not exist.

C. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

D. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

E. The audit log file does not exist in which to write audit events.

F. The audit_log.so library is not an executable file.

Consider the following: Mysql> EXPLAIN SELECT * FROM City WHERE Name = `Jacksonville' AND CountryCode = `USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where

Which statement best describes the meaning of the value for the key_len column?

A. It shows the total size of the index row.

B. It shows how many columns in the index are examined.

C. It shows the number of characters indexed in the key.

D. It shows how many bytes will be used from each index row.