Oracle Database Administration II 1z0-083 Question # 1 Topic 1 Discussion

Oracle Database Administration II 1z0-083 Question # 1 Topic 1 Discussion

1z0-083 Exam Topic 1 Question 1 Discussion:
Question #: 1
Topic #: 1

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_REDACTION_VALUES(-1); 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 zero.What must you do to activate the new default value for numeric full redaction?


A.

Re-enableredactionpoliciesthatuseFULLdataredaction.


B.

Re-createredactionpoliciesthatuseFULLdataredaction.


C.

Re-connect the sessions that access objects with redaction policies defined on them.


D.

Flushthesharedpool.


E.

Restart the database instance. Correct


Get Premium 1z0-083 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.