MySQL 5.6 Database Administrator: 1Z0-883

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.

You want to shutdown a running Mysql Server cleanly.

Which three commands that are valid on either Windows or Linux will achieve this?

A. Shell> pkill u mysql mysqld_safe

B. Shell> service mysql safe_exit

C. Shell> /etc/init.d/mysql stop

D. Shell> mysqladmin u root p shutdown

E. Mysql> STOP PROCESS mysqld;

F. Shell> net stop mysql

G. Shell> nmc mysql shutdown

Which two requirements would lead towards a high availability solution?

A. When uptime is critical

B. When data must be refactored

C. When application concurrency is static

D. When data loss is unacceptable

E. When application is a single point of failure