Question 11
Which three options are most likely to be changed for production form their default values? (Choose three.)
Question 12
Consider:
What does the range value in the type column mean?
What does the range value in the type column mean?
Question 13
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 14
What does the possible_keyscolumn in this output denote?
Question 15
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?