Online Access Free 1Z1-888 Practice Test

Which two capabilities are granted with the SUPER privilege? (Choose two.)

• A.allowing a client to shut down the server
• B.allowing change of the server runtime configuration
• C.allowing a client to kill other client connections
• D.allowing client accounts to take over the account of another user

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

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

Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A.Logical backups are human-readable whereas physical backups are not.
• B.Physical backups are usually faster than text backups.
• C.Physical backups can be used to recover from data corruption.
• D.Logical backups are always larger than physical backups.
• E.Physical backups are usually slower than text backups.

Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

• A.The .mylogin.cnf file is not readable.
• B.The mysqld instance has not been restarted after creating the login path.
• C.The host on the command line is not defined in the login path.
• D.There is no password defined in the login path.
• E.The DNS is not configured correctly for slave1 host.

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

• A.--backup-instance=/var/lib/mysql/instance2
• B.--instance=/var/lib/mysql/instance2
• C.--restore=2
• D.--defaults-file=/etc/mysql/instance2.cnf
• E.--copy-back-from-log