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

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

C.SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';

D.SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';

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

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

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

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

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

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

A.The query returns exactly 125 rows.

B.The countrytable is accessed as the first table, and then joined to the city table.

C.35 rows from the city table are included in the result.

D.It takes more than 8 milliseconds to sort the rows.

E.The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.

A.There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

B.The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C.The cluster will shut down to preserve data consistency.

D.A manual intervention to force group members to be only the working two instances is required.

E.The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

A.provides stateless firewall access to TCP/3306

B.automatic locking of user accounts who break your firewall

C.blocking of potential threats by configuring pre-approved whitelists

D.recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

E.modifying SQL statement dynamically with substitutions