MySQL5.7考试题.pdf

NO.1 To satisfy a securit y requirement , you have created or altered some user accounts to include

REQU I RE X5 0 9 .

Which addit ional t ask needs to be performed for those user accounts to fulfill the requirement t o use

X50 9?

A. Install the X509 plug-in on t he server.

B. Set t he X509 opt ion in the [client] section of the MySQL server's configuration file.

C. Restart the server with the --require-x509 option.

D. Distribute client digital cert ificates to the client computers being used to log in by t he user

account s.

B. binlog_format=STATEMENT and a non-deterministic query was executed.

C. enforce_gt id_consistency=ON and consistency is broken between the master and t he slave.

D. The sync_relay_log=1000 sett ing on t he slave is t oo small.

Answer: A,C

NO.3 You attempt t o connect to a MySQL Server by using the mysql client program. However, you

What would you run to fix t he issue?

A. the mysql_upgrade script

B. the mysql client with t he --ignore-password-hashing option

NO.4 You are using the Performance Schema to invest igate replication on a slave which has a single

master. The option slave-parallel-type is set to DATABASE.

Assume t hat all inst rument s and consumer s are enabled and all t hreads are inst rument ed.

Which t wo fact s can be concluded from the given out put?

A. The salve has t wo intermediate relay slaves connected to it .

B. The slave is configured with slave_parallel_workers = 4

C. At most, two schemas are being updates concurrently.

D. THREAD_ID 21 has stopped running.

Why does the command fail?

A. max_connections requires t he GLOBAL scope.

B. Its current user does not have t he SUPER privilege.

C. max_connections is not a dynamic variable. You need to change the config file and restart the

database.

D. Users can control only the max_user_connections variable.

Answer: A

NO.6 You have a consist ent InnoDB backup created with mysqldump, the largest table is 50 GB in

size.

shel l > mysql -u r oot -p < backup.sql

D. InnoDB has filled t he redo log and now must flush the pages.

Answer: A

NO.7 Aft er analysis on t he slow query log on a high-end OLTP service, the table identified in the slow

queries is:

What are the two most likely reasons for the slowness given t his out put?

A. Date should be a TIMESTAMP field for better performance.

B. The User field is too long for most names.

C. The engine type is not appropriat e to the applicat ion use.

A. validat e_password_policy cannot be set without restart ing the MySQL instance.

B. The name of the dict ionary file is t oo obvious.

C. The dictionary file word list is too short.

D. validat e_password_dictionary_file cannot be set without restart ing the MySQL instance.

F. The dictionary file is an insecure location.

Answer: B,F

NO.9 These details are shown when logged in t o an account:

Which set of stat ement s would match t he accounts shown?

D. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT

mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY

Answer: D

NO.10 You have a MySQL inst ance wit h the following variables in the / etc/ my.cnf file:

B. The changes caused by the UPDATE stat ement are logged to the binary log because the instance is

using --binlog-format = ROW

C. The statement would fail because you cannot update more than one row at a t ime when using -

binlogformat = ROW.

D. Nothing is logged because you are executing an UPDATE st atement t hat will cause changes to

more than one row, and you do not have the --binlog-format value set to STATEMENT.

enclosing the st atement in single quot ation marks.

Answer: D,E

NO.11 On a mast er server t hat is using stat ement-based replication, a table of log dat a has become