Online Access Free 1Z0-888 Practice Test

Which two methods will provide the total number of partitions on a table? (Choose two.)

• A.Use the command: SHOW TABLE STATUS
• B.Query the INFORMATION_SCHEMA.PARTITIONS table
• C.Query the performance_schema.objects_summary_global_by_type table
• D.Query the INFORMATION_SCHEMA.TABLES table for the partition_count
• E.Use the command: SHOW CREATE TABLE

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

• A.mysqlpasswd
• B.mysqladmin
• C.mysqld_safe
• D.mysql_config_editor

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

• A.The `adam' user must also have SELECT on the football database for backups to work.
• B.The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• C.The `adam' user must have the SUPER privilege in order to take data backups.
• D.The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

Which two statements are true regarding MySQL security? (Choose two.)

• A.The mysqld process should be run as root or administrator.
• B.The mysqld process owner should own all files and directories to which the server writes.
• C.The root or administrator users should own all files and directories to which the server writes.
• D.The mysql user needs to have sudo privileges.
• E.The mysqld process should not be run as root or administrator.

Which MySQL utility copies the master instance to a slave instance on the same host?

• A.mysqldbcopy
• B.mysqlserverclone
• C.mysqlfailover
• D.mysqlrplsync