After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:SQL> SEL
Posted: Sun Jun 11, 2023 3:51 pm
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-------------------------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 --------------------------1After 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.
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.