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