A.Your table accesses wait for the operating system level flush.

B.You use the MyISAM storage engine for most common tables.

C.The Innodb Buffer pool is full.

D.You use the InnoDB storage engine and statements wait while data is inserted.

A.Only tables stored in their own tablespaces are backed up.

B.Only InnoDB data and log files are backed up.

C.Only files for MySQL or Its built-in storage engines are backed

D.The backup includes only data files and their metadata.

E.Only non-encrypted files are backed up.

A.ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

B.ALTER TABLE employees -
ADD INDEX (birth_date);

C.ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

D.ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

E.ALTER TABLE employees -
ADD INDEX (birth_date DESC);

F.ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

A.QN = 4

B.QN = 5

C.QN = 3

D.QN = 2

E.QN = 1

A.It prevents the audit log from being removed or rotated.

B.It will force the load of the audit plugin even in case of errors at server start.

C.It prevents the audit plugin from being removed from the running server.

D.It causes the audit log to be created if it does not exist.