Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 20 of 40

Marks: +1, -0

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?

Re-enable redaction policies that use FULL data redaction.
Re-create redaction policies that use FULL data redaction.
Re-connect the sessions that access objects with redaction policies defined on them.
Flush the shared pool.
Restart the database instance

Go to Question:

Prev Question

Next Question