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.
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.
Explanation:
About Altering the Default Full Data Redaction Value
Youcanalter 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.
Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data
Redaction Value
E
E
E. Restart the database instance
E
E
E is correct.
Use the UPDATE_FULL_REDACTION_VALUES procedure to modify the default displayed
values for full redaction. After you modify a value, you must restart the database for it to take effect. You can find the current values by querying the REDACTION_VALUES_FOR_TYPE_FULL data dictionary view. (Source: Oracle Database 12c: New Features for Administrators 11 – 13, Oracle 12c Class Publication)
Globally updates the full redaction value for a given data type. You must restart the database instance before the updated values can be used.
http://docs.oracle.com/cloud/latest/db121/ASOAG/redaction_config.htm#ASOAG607
E
ORacle Database 12c: New Features for Administrators, Activity Guide – Volume I
Practices for Lesson 12: Oracle Data Redaction
Chapter 12 – Page 15
step 3. After you modify a valu, you must restart the database for it to take effect. If you only flush the buffer cache, the real value of the column will displayed.
http://docs.oracle.com/cloud/latest/db121/ASOAG/redaction_config.htm#ASOAG654
DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES
Globally updates the full redaction value for a given data type. You must restart the database instance before the updated values can be used.