Q31.What is the correct syntax for using transparent data encryption with an existing InnoDB table?
A)ALTER TABLE t1 ENCRYPTION='Y';
B)ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
C)ALTER TABLE t1 SET TDE = 'ON';
D)ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
Answer:A
Q32.Examine these statements and output:
Mysql>GRANT PROXY ON accounting@locahost TO ‘’@’%’;
Mysql>SELECT USER(),CURRENT_USER(),@@PROXY_USER;
+-------------------+---------------------+----------------+
|USER() |CURRENT_USER() |@@proxy_user|
+-------------------+---------------------+----------------+
|jsmith@loaclhost | accounting@localhost |’’@’% |
+-------------------+---------------------+----------------+
Which statement is true?
A)The user failed to define a username and the connecting username defaulted to ' '@'%'.
B)The user is authorized as the rsmith@localhost user.
C)The user is authenticated as the anonymous proxy user ' '@'%'.
D)The user is authorized as the accounting@localhost user.