MySQL Database Administration Real Exam Questions and Answers FREE 1Z1-888 Updated on Jun 28, 2022 [Q17-Q34]

NEW QUESTION 17
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.)

NEW QUESTION 18
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

NEW QUESTION 19
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

NEW QUESTION 20
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 21
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server’s binary log information?

NEW QUESTION 22
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

NEW QUESTION 23
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

NEW QUESTION 24
You are remotely logged in to MySQL as the user “backup”.
The account has temporarily been granted full privileges WITH GRANT to perform the actions required.
You want to change the password for the locally existing “backup” user.
Select the three commands which will perform the required action. (Choose three.)

NEW QUESTION 25
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

NEW QUESTION 26
Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

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

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

NEW QUESTION 29
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

NEW QUESTION 30
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

NEW QUESTION 31
You are contacted by a user who does not have permission to access a database table.
You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

NEW QUESTION 32
You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
“permissive”.
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

NEW QUESTION 33
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.)

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