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?
  • 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?
  • 1Z0-908 Exam Question 30

    Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?