Question 41
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?
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?
Question 42
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.)
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
(Choose two.)
Question 43
Which two methods will provide the total number of partitions on a table? (Choose two.)
Question 44
You have a server that has very limited memory but has a very large table.
You will use mysqldumpto back up this table.
Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
You will use mysqldumpto back up this table.
Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
Question 45
Consider the CHECK TABLEcommand.
In which two situations should this command be used? (Choose two.)
In which two situations should this command be used? (Choose two.)