18、
Choose two.
You are using mysqlcheck for server maintenance.
Which two statements are true?
A) The mysqlcheck --check --all-databases command takes table write locks while performing a
series of checks.
B) The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
C) The mysqlcheck --analyze --all-databases command performs a series of checks to spot
eventual table corruptions.
D) The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
E) The mysqlcheck --optimize --all-databases command reclaims free space from table files.
Answer:D E
A)Each table is locked and therefore unavailable to other sessions while it is being processed,
although for check operations, the table is locked with a READ lock only
B --repair, -r Perform a repair that can fix almost anything except unique keys that are not unique.
19、
Choose two.
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account?
A) ALTER USER baduser@hostname PASSWORD DISABLED;
B) ALTER USER baduser@hostname DEFAULT ROLE NONE;
C) ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
D) ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
E) ALTER USER baduser@hostname ACCOUNT LOCK;
