Question 1
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 mysqlclient to connect to the server and send clear text passwords?
(Choose two.)
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)
Question 2
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? (Choose two.)
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.)
Question 3
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.)
Question 4
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?
What are the two most likely reasons for the slowness given this output?
Question 5
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?
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?