When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.

B. Multiple BIT columns pack tightly into a row, using less space.

C. BIT (8) takes less space than eight TINYINT fields.

D. The BIT columns can be manipulated with the bitwise operators and, |, ~, ^, <<, and >>. The other integer types cannot.

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.

Which two will optimize the security of this setup?

A. Disabling connections from named pipes or socket files (depending on the operating system of the server)

B. Running the server with skip-networking specified

C. Limiting logins to originate from the application server or the server's subnet

D. Starting the server with bind- address=0.0.0.0 specified

E. Installing Mysql on the application server, and running the database and application on the same server

F. Enabling and using SSL for connections to the Mysql database

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

A. It is provided by means of IP- level disk replication.

B. It is shared-nothing architecture.

C. It implements High Availability by using the .NET Connector's load balancing capabilities.

D. It relies on the shared disk architecture being visible to both servers.

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.

Consider the MySQL Enterprise Audit plugin.

On attempting to start the MySQL service after a crash, notice the following error:

[ERROR] Plugin `audit_log' init function returned error.

In the audit log file, you notice the final entry:

...

TIMESTAMP="2013-07-09T02:12:35"

NAME="Connect"

CONNECTION_ID="98"

STATUS="0"

USER="Kate"

PRIV_USER="kate"

OS_LOGIN=""

HOST="localhost"

DB=""/>

What action should you take to fix the error and allow the service to start?

A. Re-install the audit plugin.

B. Execute the command FLUSH LOGS.

C. Execute the command SET GLOBAL audit_log_fiush= ON.

D. Move or rename the existing audit.log file.