After implementing full Oracle Data Redaction, you change the default
Value for the NUMBER data type as follows:
SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
------------
0
SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1);
SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
------------
-1
After changing the value, you notice that FULL redaction continues to redact
Numeric data with zero.(您注意到 FULL 编校继续以零编校数值数据)也就是
上面的修改还没有生效,该命令是把 number 的数据类型编辑以后默认值为-1)。
What must you do to activate the new default value for numeric full
Redaction?
A.正确答案ERe-enable redaction policies that use FULL data redaction.
B.Re-create redaction policies that use FULL data redaction.
C.Re-connect the sessions that access objects with redaction policies defined on
Them.
D.Flush t he shared pool.
E.Restart the database instance.