291.ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
Answer: C
ENCRYPT_TS是一个包含数据表的加密的表空间。关于在表中的加密数据的查询效果和数据操作语言(DML)语句,哪种说法是正确的?
C、当它被存储在重做日志中数据保持加密状态。
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN12327
To maximize security, data from an encrypted tablespace is automatically encrypted when written to the undo tablespace, to the redo logs, and to any temporary tablespace. There is no need to explicitly create encrypted undo or temporary tablespaces, and in fact, you cannot specify encryption for those tablespace types.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123757/
,如需转载,请注明出处,否则将追究法律责任。