A.a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

B.A text backup. A binary backup will still contain the corrupted segments.

C.A text backup. InnoDB does not allow you to make binary backups while the server is running.

D.a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

A.The schema and data are automatically dumped to separate files.

B.It can be used together with --all-databases.

C.It can be piped directly into a running server.

D.It is possible to restore the data in parallel.

A.The table will be scanned over a certain range of values.

B.You can use an index and return rows that fall within a range of values.

C.There is a range of indexes that can be used.

D.This type of index uses the range hash.

A.GRANT SELECT ON world.* TO [email protected];

B.GRANT SELECT ON world.* TO [email protected];

C.GRANT SELECT ON audit.* TO [email protected];

D.CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

E.GRANT INSERT ON audit.* TO [email protected];

F.GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

G.GRANT DELETE ON world.* TO [email protected];

A.Backup State = Prepared BackupOperation = apply-log

B.Backup State = Raw BackupOperation = apply-log

C.Backup State = Raw BackupOperation = backupdir-to-image

D.Backup State = Prepared BackupOperation = validate

E.Backup State = Compressed BackupOperation = copy-back