Oracle
1Z0-067 · Question #167
1Z0-067 Question #167: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #167. The question stem and answer options stay visible for context.
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 ------------------------- 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 ------------------------ 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.
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.