A.It fails if any of the roles is specified in the mandatory_roles variable.

B.It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

C.It fails if at least one of the roles does not exist.

D.You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

E.You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

F.Existing connections can continue to use the roles' privileges until they reconnect.

A.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

B.It adds more temporary workspace in addition to the innodb_tmpdir location.

C.It defines all innodb tablespace options relative to a starting parent directory.

D.It is not necessary because innodb_data_home_dir is already defined.

E.It allows scanning of other locations to discover more innodb tablespaces.

A.It is stored in the mysql.role table.

B.It can be dropped using the DROP ROLE statement.

C.It can be granted to user accounts.

D.It can be protected with a password.

E.It can be renamed using the RENAME ROLE statement.

F.It is created as a locked account.

A.user privileges

B.primary indexes

C.InnoDB Data Dictionary

D.table data

E.change buffer

F.doublewrite buffer

A.It enforces consistent backups for all storage engines.

B.It is a cold backup.

C.It executes flush tables with read lock.

D.The backup created is a consistent data dump.

E.This option uses the READ COMMITTED transaction isolation mode.