Which two statements about this policy are true?
A.
It replaces the first four digits of the value from the SALARY column with the number 9.
B.
It replaces the first digit of the value from the SALARY column with the number 4.
C.
It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.
D.
It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.
E.
It uses the full data redaction method.
F.
It uses the random redaction method.
Answer is
when policy added it was A
when policy modified it is C
Reference:
For number datatypes, a comma-separated list containing
these fields:
■ Mask character: this is a character between ‘0’ to ‘9’ that
will be used to replace the actual values.
■ Starting digit position: specifies the starting (digit)
position to begin replacing actual values with the masking
character. The beginning of the string is position 1.
Positions do not include the decimal point.
■ Ending digit position: this specifies the ending digit
position to end masking. An example is ‘9,1,5’ for
masking the first 5 digits of a Social Security number
number 123456789, resulting in 999996789.
of http://docs.oracle.com/database/121/ARPLS/E41829-05.pdf
When policy added : A
When policy altered: Both A and C
NOTE: add and alter policy are applying redaction on different columns.
Correct Ans: A,C
https://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG816