Oracle Data Redaction is active on the table. SCOTT.EMP 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
  78% (45)
• B
  12% (7)
• C
  3% (2)
• D
  5% (3)
• E
  2% (1)

Explanation

Oracle Data Redaction has three modes: FULL, PARTIAL, and RANDOM. The critical behavioral difference is consistency across executions. FULL redaction always returns the same fixed replacement value - 0 for NUMBER columns and a space for character columns - every single time the query runs. RANDOM redaction, by contrast, generates a different random value on each query execution, meaning the same row will show different values if queried twice. PARTIAL redaction consistently masks a portion of the real value (e.g., showing only the last 4 digits of a credit card number), also returning stable results across runs. The fact that the same query was issued twice is the key clue. If RANDOM redaction were active on MGR (choice B) or HIREDATE (choice C), the values returned in the second query would differ from the first - making those answers unprovable as 'guaranteed.' FULL redaction on SAL, a NUMBER column, is guaranteed to always display 0 regardless of how many times the query runs, making it the only statement that can be asserted with certainty. Choices D and E (PARTIAL on MGR or HIREDATE) cannot be distinguished from FULL just by running the query twice, and the exam targets the definitive, observable guarantee of FULL redaction's fixed output.

No community discussion yet for this question.