Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE…

Question

Exhibits

Options

• AFULL redaction is active on the SAL column
• BRANDOM redaction is active on the MGR column
• CRANDOM redaction is active on the HIREDATE column
• DPARTIAL redaction is active on the MGR column.
• EPARTIAL redaction is active of the HIREDATE column.

• A
  5% (2)
• B
  23% (9)
• C
  63% (25)
• D
  8% (3)
• E
  3% (1)

Explanation

Option C is correct because Oracle Data Redaction does not support PARTIAL redaction on DATE columns - only character and numeric types are eligible for partial masking. Since HIREDATE is a DATE, PARTIAL is impossible (eliminating E), and FULL redaction on a date always returns the same fixed value (01-JAN-01), meaning it would look identical across both queries. The only redaction type on a DATE column that produces different values between successive queries is RANDOM - which is exactly what two runs of the same query can reveal. Options A, B, and D are not "guaranteed" because SAL and MGR are numeric columns that could legitimately have FULL, PARTIAL, or RANDOM redaction applied; nothing in the scenario rules those types in or out for those columns.

Memory tip: "DATE columns can't be PARTially hidden - they go RANDOM or FULL." Whenever you see a DATE column as an answer choice paired with PARTIAL redaction, eliminate it immediately.