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

NEW QUESTION 80
Consider these global status variables:

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

NEW QUESTION 81
You have created a new user with this statement:
CREATE USER `erika’@’localhost’ IDENTIFIED BY `first#1Pass’ PASSWORD EXPIRE; What is the outcome?

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

NEW QUESTION 83
Which two statements are true about InnoDB auto-increment locking? (Choose two.)

NEW QUESTION 84
What two statements are true regarding FLUSH TABLES FOR EXPORT?

NEW QUESTION 85
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

NEW QUESTION 86
Consider:

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

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

Which set of statements would match the accounts shown?

NEW QUESTION 88
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

NEW QUESTION 89
Multiversion Concurrency Control (MVCC) enables what type of backup?

NEW QUESTION 90
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 STATUSindicates these values:
RELAY_LOG_FILE=hostname-relay-bin.00004

RELAY_LOG_POS=1383

Which command set would make the slave current?

NEW QUESTION 91
Multiversion Concurrency Control (MVCC) enables what type of backup?

NEW QUESTION 92
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis 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? (Choose two.)

NEW QUESTION 93
Consider the table people with the 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?

NEW QUESTION 94
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 95
After rebooting the host, you attempt to start the mysqldservice. You get the following error:
Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

NEW QUESTION 96
Which two options describe how MySQL Server allocates memory?

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

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

NEW QUESTION 99
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
(Choose two.)

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