Provide Oracle 1Z1-888 Dumps Updated Aug 01, 2022 With 155 QA’s [Q64-Q85]

QUESTION 64
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

QUESTION 65
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? (Choose two.)

QUESTION 66
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

QUESTION 67
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?

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

QUESTION 69
The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

QUESTION 70
Examine the mydata table and SELECT statements:

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?

QUESTION 71
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

QUESTION 72
Consider these global status variables:

Which two conclusions can be made from the output?

QUESTION 73
Which two statements describe how InnoDB recovery works? (Choose two.)

QUESTION 74
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?

QUESTION 75
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?

QUESTION 76
Which three statements correctly describe MySQL InnoDB Cluster?

QUESTION 77
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?

QUESTION 78
Examine the mydata table and SELECT statements:

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?

QUESTION 79
Consider the key buffer in a MySQL server. Which two statements are true about this feature?

QUESTION 80
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 mysql client to connect to the server and send clear text passwords?

QUESTION 81
You are looking at these details:

Why does the message “Waiting for an event from Coordinator” show up on the slave_worker threads?

QUESTION 82
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?

QUESTION 83
Consider these global status variables:

Which two conclusions can be made from the output?

QUESTION 84
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.)

QUESTION 85
You have created a backup of the ‘sales’ database with the command:

Which two procedures can be used to restore the ‘orders’ table from the backup?