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 a zero. What must you do to activate the new default value for numeric full redaction? 

Answer options:

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

About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect. Note: * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application. * UPDATE_FULL_REDACTION_VALUES Procedure This procedure modifies the default displayed values for a Data Redaction policy for full redaction. * After you create the Data Redaction policy, it is automatically enabled and ready to redact data. * Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods: / Full redaction. / Partial redaction. / Regular expressions. / Random redaction. / No redaction.