Which query would you use to find connections that are in the same state for longer than 180 seconds?
A. SHOW FULL PROCESSLIST WHEER Time > 180;
B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
C. SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
D. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;
In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?
A. Disk usage when storing data
B. Syntax when writing queries involving JOINS
C. Comparing the encoded data with similar columns on other tables
D. Memory usage when working with the data
E. Character set mapping index hash size
You want a record of all queries that are not using indexes. How would you achieve this?
A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B. By enabling the Error Log because not using indexes is an error
C. By enabling the Slow Query Log and using the log-queries-not-using-indexes option
D. By enabling the Error Log and using the log-queries-not-using-indexes option
Which three statements describe how the strict SQL mode provides added security?
A. It rejects statements that try to insert out-of-range values
B. It rejects invalid dates.
C. It limits the operations that the server can perform.
D. It rejects queries that produce out-of-range values.
E. It rejects dates with zero day or month values.
A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event.
The server is configured with:
You have identified that the DELETE statement to skip has the Global Transaction Identifier (GTID)
`dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with:
Mysqlbinlog exclude-gtides=' dbbe07da-fe25-11e2-b6c7-0800274aa49e:5' binlog.00000.2 | mysql
However all events were skipped instead of just the one deleting the wrong row.
What is the reason for this?
A. Mysqlbinlog ignores arguments to exclude-gtids-it means ignore all events with GTIDs.
B. The server keeps track of which GTIDs have already been executed and skips those.
C. Enforce_gtid_consistency is set to ON.
D. Gtid_mode must be set to AUTO during point in time recoveries.
Which two requirements would lead towards a high availability solution?
A. When uptime is critical
B. When data must be refactored
C. When application concurrency is static
D. When data loss is unacceptable
E. When application is a single point of failure
You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option `--ssl'
What is the cause of the error?
A. The --- ssl level was not specified.
B. The server was not started with the enable--ssl-plugin option.
C. -- ssl is not a valid server option.
D. The mysqld binary was not compiled with SSL support.
E. The server's SSL certificate was invalid.
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data: `GREEN01020495888331993-12-10/2...'
What should you do to improve the overall performance?
A. Convert the column to TEXT and add a fulltext index to the table.
B. Create multiple prefix indexes of differing lengths.
C. Convert their column to BINARY.
D. Redesign the table so that the most commonly searched for string patterns are in their own columns.
Which three statements are true about memory buffer allocation by a MySQL Server?
A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
D. User buffers are allocated at server startup and freed when the user is dropped.
E. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
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?
A. Include-master-info
B. Master-binlog
C. Include-log-file
D. Master-data
