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_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
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 a 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
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.
E
E
E
C.
Note: Database bounce would require to take effect of changed value.
http://dbatricksworld.com/full-data-redaction-policy-data-redaction-part-iii/
so the rite ans is C ?
Sorry i mean E.
Note: Database bounce would require to take effect of changed value.
http://dbatricksworld.com/full-data-redaction-policy-data-redaction-part-iii/
Taking exam on 25-mar-2016. Keep in touch. http://www.facebook.com/tri.ho.378
E
https://docs.oracle.com/cd/E11882_01/network.112/e40393/redaction_config.htm#ASOAG10490
Globally updates the full redaction value for a given data type. You must restart the database instance before the updated values can be used.
E