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 have forgotten the root user account password. You decide to reset the password and execute the following:

Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start skip-grant tables

Which additional argument makes this operation safer?

A. --skip-networking, to prohibit access from remote locations

B. --reset-grant-tables, to start the server with only the mysql database accessible

C. --read-only,to set all data to read-only except for super users

D. --old-passwords, to start Mysql to use the old password format while running without the grant tables

An employee cannot access the company database. You check the connection variables: Mysql> SHOW GLOBAL VARIABLES LIKE `%connect%';

8 rows in set (0.00 sec)

A look at the user privileges shows:

GRANT... TO `bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO `key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO `joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50;

What is a valid explanation for why one of the users is unable to connect to the database?

A. Bob has max_user_connections set to zero, which blocks all his connections

B. Joe has exceeded the max_user_connections global limit.

C. All users are blocked because max_user_connections is accumulated over the host account information.

D. Kay is already connected elsewhere and attempting to log in again.

E. Connect_timeout is too small to allow a connection to occur.