QUESTION 113 -- 10g OCP 升级11g OCP 1Z0-053

最新推荐文章于 2019-08-30 09:56:54 发布

chinadm123

最新推荐文章于 2019-08-30 09:56:54 发布

阅读量682

点赞数

分类专栏：通过11g OCP 题库学习新特性

本文链接：https://blog.csdn.net/chinadm123/article/details/43936797

版权

通过11g OCP 题库学习新特性专栏收录该内容

4 篇文章 0 订阅

订阅专栏

QUESTION 113

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

comments:

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.

reference: Oracle® Database Administrator's Guide11g Release 2 (11.2) Part Number E10595-07