QUESTION 168-Data Redaction

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;

ENAME SAL COMM MGR HIREDATE

----------------------- --------------------- -------------------- -------------------- --------------------------

ALLEN 0 300 9998 10-SEP-18

WARD 0 500 9998 15-OCT-15

MARIN 0 1400 9998 10-FEB-19

BLAKE 0 9999 11-MAY-49

TURNER 0 0 9998 20-MAY-21

JAMES 0 9998 04-JUN-24

 

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

ENAME SAL COMM MGR HIREDATE

----------------------- --------------------- -------------------- -------------------- --------------------------

ALLEN 0 300 9998 26-NOV-77

WARD 0 500 9998 04-JUN-29

MARIN 0 1400 9998 21-DEC-10

BLAKE 0 9999 25-DEC-95

TURNER 0 0 9998 01-JAN-33

JAMES 0 9998 15-JAN-47

 

Which is guaranteed to be true concerning the redaction policy?

 

A. FULL redaction is active on the SAL column

B. RANDOM redaction is active on the MGR column

C. RANDOM redaction is active on the HIREDATE column

D. PARTIAL redaction is active on the MGR column.

E. PARTIAL redaction is active of the HIREDATE column.

Correct Answer: A