A.Execute the sakila-data. sqi script to populate the database

B.Use MySQL Enterprise High Availability to access one of the available data tables

C.Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

D.Use mysqldump to import data from the sakila_dummy database sample data set.

A.Grant only permissions that a user requires.

B.Ensure that MySQL accounts have short and easy passwords.

C.Use the secure installation script "mysql_alays_secure_installation".

D.Use a firewall to control access to MySQL ports.

E.Transmit plain (unencrypted) data over networks.

F.Allow unauthorized clients to connect to the server.

A.SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

B.SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

C.SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

D.SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

A.0

B.TRUE

C.NULL

D.FALSE

E.1

A.CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)

B.CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE

C.CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')

D.CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY 'SecretPass123!';

E.CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;