QUESTION 37
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)
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?
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.
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
Explanation:
About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications.
You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.
问题37
在实现完整的Oracle数据编校之后，您需要修改NUMBER数据类型的默认值，如下所示:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
------------
0
SQL > EXEC DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES (1)
PL/SQL过程成功完成。
SQL> select number_value from redaction_values_for_type_full;
NUMBER_VALUE
------------
1
在更改值之后，您会注意到完整编校将继续编校带有0的数字数据。必须做什么才能激活数字完整编校的新默认值?
A.重新启用使用完整数据修订的修订策略。
B.重新创建使用完整数据修订的修订策略。
c.用定义在其上的编校策略重新连接访问对象的会话。
D.刷新共享池。
E.重新启动数据库实例。
正确答案:E
部分:(一)
解释
解释/参考:
解释:
关于更改默认的完整数据编校值您可以更改完整数据编校策略的默认显示值。默认情况下，当Oracle数据库对NUMBER数据类型的列执行完全编校(dbms_编校。full)时，0是编校值。如果您想将其更改为另一个值(例如，7)，那么您可以运行DBMS_REDACT。UPDATE_FULL_REDACTION_VALUES过程修改这个值。修改应用于当前数据库实例中的所有数据编校策略。修改值后，需要重启数据库才能生效。
注意:
DBMS_REDACT包提供了一个Oracle数据编校的接口，可以屏蔽(编校)低权限用户或应用程序发出的查询返回的数据。
UPDATE_FULL_REDACTION_VALUES过程该过程修改数据编校策略的默认显示值，用于完全编校。
*创建数据编校策略后，自动启用并准备编校数据。
Oracle数据编校允许您屏蔽(编校)低权限用户或应用程序查询返回的数据。
您可以使用下列方法之一编校列数据:
/全面修订。
/部分修订。
/正则表达式。
/随机修订。
/不修订。