[Jun-2022] Oracle 1Z1-888 DUMPS WITH REAL EXAM QUESTIONS [Q63-Q86]

Q63. You have a MySQL instance with the following variables in the /etc/my.cnf file:

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

Q64. You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

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

Q66. To query two system variables, you execute this statement and get the results shown:

When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?

Q67. Consider the table people with this definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

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

Q69. Which MySQL utility copies the master instance to a slave instance on the same host?

Q70. You have issued this statement:
GRANT PROXY ON ‘a’ FOR ‘b’;
When user account ‘b’ issues a query, the query returns an access denied error.
What could have caused that error?

Q71. An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

Q72. Which two options describe how MySQL Server allocates memory? (Choose two.)

Q73. What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)

Q74. Consider:

Which statement best describes the meaning of the value for the key_len column?

Q75. 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?

Q76. What is the best method for monitoring Group Replication conflict resolution?

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

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

Q79. You want to immediately stop access to a database server for remote user
‘mike’@’client.example.com’. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)

Q80. You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

Q81. 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?

Q82. 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.)

Q83. Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

Q84. Why should you be selective when granting the PROCESS privilege to an account?

Q85. You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

Q86. A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERT statement commits.
Which list of locations is in the sequence of disk writes for this transaction?