mysql8.0英文OCP考试第121-130题

Q121.Examine these statements and output:

mysql> GRANT PROXY ON accounting@localhost TO ' '@ '%';

mysql> SELECT USER(), CURRENT_ USER(), @@proxy_ user;

+------------------------+-------------------+-----------------+

|USER()                    I CURRENT_ USER()   I @@proxy_ user    I

| r smith@localhost 1        |accounting@localhost I ' '@'%'            |

+------------------------+-------------------+-----------------+

Which statement is true?

A)The user failed to define a username and the connecting username defaulted to ''G'8'.

B)The user is authorized as the rsmith@localhost user.

C)The user is authenticated as the anonymous proxy user ' '@ '%'.

D)The user is logged in with --user=accounting as an option.

E)The user is authorized as the accounting@localhost user.

Answer:E

Q122.Which two actions can obtain information about deadlocks?

A)Run the SHOW ENGINE INNODB MUTEX command from the mysql client.

B)Enable the innodb_ status_ output_ locks global parameter.

C)Enable the innodb_ print_ all_ deadlocks global parameter.

D)Run the SHOW ENGINE INNODB STATUS command from the mysql client.

E)Use the sys. innodb_ lock_ waits view.

Answer:CD

Q123.Examine this statement, which executes successfully:

CREATE TABLE world.city(

ID int NOT NULL AUTO_ INCREMENT ,

Name char(35) NOT NULL DEFAULT '' ,

CountryCode char(35) NOT NULL DE