After implementing full Oracle Data Redaction, you change the default value for the
NUMBER data type as follows: After changing the value, you notice that FULL redaction
continues to redact numeric data with zero. What must you do to activate the new default
value for numeric full redaction?
A.
Restart the database instance.
B.
Flush the shared pool.
C.
Re-connect the sessions that access objects with redaction policies defined on them.
D.
Re-enable redaction policies that use FULL data redaction.
E.
Re-create redaction policies that use FULL data redaction.
A.
Once you modify a redaction value, the new values won’t go into effect immediately—you must bounce the database for the change to take effect. Therefore, this is kind of a limitation in a production environment when you can’t easily restart the database.