MySQL考试

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

发布于 2021-02-25 23:45:12

【单选题】
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';

关注者

0

被浏览

81

刘明明 2023-02-25

成功来自使我们成功的信念。

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

至尊黄铜

这家伙很懒，什么也没写！

提问

回答

1010

被采纳

1008

关注TA

发私信

相关问题

1

<{p}>X、Y两元素的相对原子质量之比为7：2，由它们组成的某化合物中，X、Y两元素的质量比为21：8，则这种化合物的化学式为（　　）<{br/}><{/p}>

2

<{p}>You are having performance issues with MySQL instances.<{/p}><{p}>Those servers are monitored with MySQL Enterprise Monitor.<{/p}><{p}>Using Query Analyzer, where do you begin to look for problem queries?<{/p}>

3

<{p}>You encountered an insufficient privilege error in the middle of a long transaction.<{br/}>The database administrator is informed and immediately grants the required privilege:<{br/}> GRANT UPDATE ON world.city TO 'user1';<{br/}>How can you proceed with your transaction with the least interruption?<{/p}>

4

在签订（预签）有关合同文本前，应履行充分（）义务。

5

<{p}>You want to check the values of the sort_buffer_size session variables of all existing connections.<{/p}><{p}>Which performance_schema table can you query?<{/p}>

6

<{p}>Examine this command, which executes successfully:<{/p}><{p}> $mysqlbackup --user=dba --password --port=3306 --with-timestamp --only-know-file-types --backup-dir=/exprot/backups backup<{/p}><{p}>Which statement is true?<{/p}>

7

企业取得生产许可证,应当符合下列哪些条件()。

8

<{p}>You want to dump all databases with names that start with "db".<{/p}><{p}>Which command will achieve this?<{/p}>

9

<{p}>Examine this parameter setting:<{/p}><{p}> audit_log=FORCE_LOG_OERMAENT<{/p}><{p}>What effect does this have on auditing?<{/p}>

10

<{p}>You recently upgraded your MYSQL installation to MYSQL8.0 Examine this client error:<{br/}>Error 2059 (HY000):authentication plugin ‘caching_sha2_password’ cannot be Loaded: /usr/local/mysql/libplugin/caching_sha2_password.so: cannot open shared object file: No such or directory<{br/}>Which option will allow this client to connect to MySQL Server?<{/p}>

发布
问题

手机
浏览

扫码手机浏览

在线
客服