You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, “Hello”); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)
Which three statements are true about MySQL replication? (Choose three.)