A.Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.

B.Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

C.Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

D.Execute SET GLOBAL log_error = '<new error log file>'.

A.WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘;

B.SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

C.WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;

D.SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

E.SELECT email,passwd FROM members

F.SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

A.mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

B.mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

C.mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

D.mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

A.ALTER USER baduser@hostname ACCOUNT LOCK;

B.ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

C.ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

D.ALTER USER baduser@hostname PASSWORD DISABLED;

E.ALTER USER baduser@hostname DEFAULT ROLE NONE;

A.named pipes

B.shared memory

C.SOCKET

D.X Protocol

E.UDP

F.TCP/IP