Get New 2022 Valid Practice To your 1Z0-888 Exam (Updated 155 Questions) [Q28-Q51]

NO.28 You created a backup of the worlddatabase with this command:
shell> mysqldump –opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

NO.29 You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S’ in a number of locations in the output.
What does the N indicate?

NO.30 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.)

NO.31 Examine the mydatatable and SELECTstatements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

NO.32 You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

NO.33 A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

NO.34 Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

NO.35 What is the order of tables shown in an EXPLAIN output?

NO.36 Where does MySQL Linux RPM install the mysqld binary?

NO.37 Which three statements correctly describe MySQL InnoDB Cluster?

NO.38 Consider these global status variables:

Which two conclusions can be made from the output?

NO.39 Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

NO.40 How does the InnoDB storage engine handle deadlocks when they are detected?

NO.41 You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

NO.42 A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable” on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

NO.43 Where does MySQL Linux RPM install the mysqld binary?

NO.44 A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

NO.45 Which three options are most likely to be changed for production form their default values? (Choose three.)

NO.46 You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

NO.47 The Performance Schema includes these tables related to status variables:

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

NO.48 Which two general properties relate to the mysqlimport client program? (Choose two.)

NO.49 A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

NO.50 Consider:

Which statement best describes the meaning of the values in the ref columns?

NO.51 You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?