1z0-908 Exam Dumps : MySQL 8.0 Database Administrator

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.)

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

You are backing up raw InnoDB files by using mysqlbackup.

Which two groups of files will be backed up during a full backup? (Choose two.)