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?
Examine these statements, which execute successfully:CREATE ROLE r_world_rd;GRANT SELECT ON world.* TO r_world_rd;CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;GRANT r_world_rd TO john;Examine these statements issued by user John:What is the reason for the error?
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.Which command will do this?
Examine this MySQL Shell command:dba.rebootClusterFromCompleteOutage()Which two statements are true? (Choose two.)
Which two statements are true about MySQL server multi-source replication? (Choose two.)
Examine this statement, which executes successfully:You want to improve the performance of this query:Which change enables the query to succeed while accessing fewer rows?
