You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts

successfully as verified by the following commands:

$ pidof mysqld

3132

$tail - n2 /var/lib.mysql/hostname.err

2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.

Version: ‘5.6.13-enterprise-commercial-advaced’ socket: ‘/tmp/mysql.sock’ port;

3306 Mysql Enterprise Server – Advanced Edition (Commercial)

You attempt to log in as the root user with the following command:

$mysql –u root

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Which statement is true about this scenario?

A. The RPM installation script sets a default password of password for new installations.

B. The local root user must log in with a blank password initially: mysql u root p.

C. New security measures mean that the mysql_secure_installation script must be run first on all new installations.

D. The mysql_install_bd post-installation script used random-password.

Identify a performance impact when using the Performance Schema.

A. There is no impact on performance.

B. There is an overhead for querying the Performance Schema but not for having it enabled.

C. There is a constant overhead regardless of settings and workload.

D. The overhead depends on the settings of the Performance Schema.

Which two statements are true regarding partitioning in Mysql?

A. Tables with BLOB and TEXT columns cannot be partitioned.

B. Partitioning allows easier management of smaller data sets for certain queries.

C. Partitioning allows different columns to be stored in separate files.

D. The partitioning expression is an integer or function that returns an integer value or NULL value.

E. Partitioning is only available for those storage engines that implements it natively.

You have been notified that the `apps' . `reports' table has been accidentally truncated.

You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the `apps' . `reports' table must be restored without affecting the other remaining databases and tables.

Which restore option is suitable in this scenario?

A. Restore the backup to another databases instance and obtain a copy of the reports table individually.

B. Extract the `apps' . `reports' table from the backup using the SOURCE command.

C. Execute LOAD DATA INFILE `backup.sql' SCHEMA='apps' TABLE= `reports'

D. Execute mysqldump on the backup,sql file and apply filter arguments to obtain only the `apps' . `reportys' table.

What are three facts about backups with mysqldump?

A. Can back up a remote database server

B. Allow a consistent backup to be taken

C. Are always faster to restore than binary backups

D. Are able to back up specific items within a database

E. Create automatically compressed backups

F. Will lock all storage engines for duration of backup