Question 146
Which statement is true about tablespaces?
Question 147
Which three options are most likely to be changed for production form their default values? (Choose three.)
Question 148
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 149
While attempting to set up a new replication slave on host '192.168.0.25' with the user 'replication', you encounter this error:
What should you do to resolve this error?
What should you do to resolve this error?
Question 150
You have forgotten the rootuser account password. You decide to reset the password and execute:
Which additional argument makes this operation safer?
Which additional argument makes this operation safer?