Question 1

You execute this command:shell> mysqlpump --exclude-databases=% --usersWhich statement is true?

Options :

A : It creates a logical backup of all MySQL user accounts.

B : It creates a logical backup of all metadata, but contains no table data.

C : It returns an error because the mysqldump command should have been used.

D : It creates a logical backup of only the users database.

Answer: B

Question 2

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.You then TRUNCATE this table to empty it.mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;mysql> TRUNCATE t1;Which two methods will restore data to the t1 table? (Choose two.)

Options :

A : mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B : $ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 3

You are attempting to secure a MySQL server by using SSL encryption.On starting MySQL, you get this error:[ERROR] mysqld: unknown option ‘--ssl’What is the cause of the error?

Options :

A : The -- ssl level was not specified.

B : The server was not started with the --enable–ssl-plugin option.

C : --ssl is not a valid server option.

D : The mysqld binary was not compiled with SSL support.

E : The server’s SSL certificate was invalid.

Answer: D

Question 4

Your MySQL environment has asynchronous position based-replication with one master and one slave.The slave instance had a disk I/O problem, so it was stopped.You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.You restart MySQL Server.How can replication be restored?

Options :

A : The slave relay logs should be deleted; then execute START SLAVE;

B : The relay logs from the master should be used to replace the corrupted relay logs.

C : The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : The slave needs to be restored from backup.

Answer: B

Question 5

Which three are properties of the MyISAM storage engine? (Choose three.)

Options :

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B