1Z0-908 Exam Question 26
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?
1Z0-908 Exam Question 27
Which command enables rule-based MySQL Auditing capabilities?
1Z0-908 Exam Question 28
Which step or set of steps can be used to rotate the error log?
1Z0-908 Exam Question 29
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?
1Z0-908 Exam Question 30
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
