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.Re-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 the shared pool. E.Restart the database instance.正确答案E
