nerdexam
Oracle

1Z0-063 · Question #134

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>…

The correct answer is E. Restart the database instance. See the full explanation below for the reasoning.

Question

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?

Options

  • ARe-enable redaction policies that use FULL data redaction.
  • BRe-create redaction policies that use FULL data redaction.
  • CRe-connect the sessions that access objects with redaction policies defined on them.
  • DFlush the shared pool.
  • ERestart the database instance.

How the community answered

(35 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    3% (1)
  • D
    9% (3)
  • E
    80% (28)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice