[2022] Use Valid New 1Z0-888 Test Notes & 1Z0-888 Valid Exam Guide [Q37-Q60]

NEW QUESTION 37
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?
(Choose three.)

NEW QUESTION 38
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

NEW QUESTION 39
old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

NEW QUESTION 40
Which are three facts about backups with mysqldump? (Choose three.)

NEW QUESTION 41
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)

NEW QUESTION 42
On a master server that is using statement-based replication, a table of log data has become very large. You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

NEW QUESTION 43
An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

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

NEW QUESTION 44
Which two statements describe how InnoDB recovery works?

NEW QUESTION 45
old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

NEW QUESTION 46
How does the InnoDB storage engine handle deadlocks when they are detected?

NEW QUESTION 47
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

NEW QUESTION 48
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

NEW QUESTION 49
Which statement is correct about how InnoDB storage engine uses disk space?

NEW QUESTION 50
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be “rolled forward” to provide all the latest datA.
The SHOW SLAVE STATUS indicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

NEW QUESTION 51
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

NEW QUESTION 52
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

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

NEW QUESTION 54
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?

NEW QUESTION 55
A MySQL replication slave is set up as follows:
* Uses all InnoDB tables
* Receives ROW-based binary logs
* Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

NEW QUESTION 56
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

NEW QUESTION 57
Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

NEW QUESTION 58
You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
* The Table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?

NEW QUESTION 59
Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

NEW QUESTION 60
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?