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

B.It can be granted to user accounts.

C.It is created as a locked account.

D.It can be protected with a password.

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

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

A.any user set as DEFINER for stored programs

B.any new ROLE accounts

C.any user created without a password

D.any internal system accounts

E.any user created with a username, but missing the host name

A.monitoring OS resources for patterns

B.buying more RAM

C.consulting the application team about any future projects and use

D.adding circular replication nodes for increased DML capability

E.buying more disk

F.basing expected growth on an average of the last 3 years

G.buying more CPU

H.upgrading to the latest application version

A.The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

B.MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

C.MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

D.MySQL keeps InnoDB metadata changes in .sdi files in datadir.

E.MySQL writes SDI to the binary log for distributed backups.

A.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

C.The mysqlcheck --optimize --all-databases command reclaims free space from table files.

D.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

E.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.