1Z0-060 · Question #165
You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements: - RANDOM redaction on the SAL and COMM columns - PARTIAL redaction on the HIREDATE column - FULL…
The correct answer is C. one redaction policy on the table, which specifies the redaction types for all table columns that. You can redact columns of different data types, using different redaction types, for one table or 1. Create the policy for the first column that you want to redact. 2. Use the DBMS_REDACT.ALTER_POLICY procedure to add the next column to the policy.
Question
You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
- RANDOM redaction on the SAL and COMM columns
- PARTIAL redaction on the HIREDATE column
- FULL redaction on the MGR column
What would you define to implement this?
Options
- Aseveral redaction policies, with one redaction policy foe each data type defined for the table must
- Bseveral redaction policies, with each redaction policy specifying the redaction for table columns of
- Cone redaction policy on the table, which specifies the redaction types for all table columns that
- Dseveral redaction policies, with one redaction policy for each table column that must be redacted
How the community answered
(38 responses)- A5% (2)
- B13% (5)
- C76% (29)
- D5% (2)
Explanation
You can redact columns of different data types, using different redaction types, for one table or 1. Create the policy for the first column that you want to redact. 2. Use the DBMS_REDACT.ALTER_POLICY procedure to add the next column to the policy.
Topics
Community Discussion
No community discussion yet for this question.