1z0-888 Free Practice Test

Is it true that binary backups always take less space than text backups?

1. A. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
2. B. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
3. C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
4. D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.

Correct Answer: C

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?

1. A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
2. B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
3. C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
4. D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
5. E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Correct Answer: BE

Which two statements describe how InnoDB recovery works?

1. A. InnoDB handles most crash recoveries automatically.
2. B. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
3. C. There will in general be lost committed transactions after a crash using the default settings.
4. D. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
5. E. It is recommended to set innodb_force_recovery = 1 as part of normal operations.
6. F. It is always required to enable innodb_force_recovery to perform a crash recover

Correct Answer: BF

old_alter_table is disabled as shown. mysql> SELECT @@old_alter_table;
<>>

1. A. All data in p1 and p3 partitions is removed and the table definition is changed.
2. B. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
3. C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
4. D. It results in a syntax error because you cannot specify more than one partition in the same statemen

Correct Answer: B

You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORDEXPIRE; What is the outcome?

1. A. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
2. B. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
3. C. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
4. D. You receive a syntax error that indicates that you cannot set a password and expire it at the same tim

Correct Answer: A