You execute the following piece of code with appropriate privileges: User SCOTT has been
granted the CREATE SESSION privilege and the MGR role. Which two statements are true
when a session logged in as SCOTT queries the SAL column in the view and the table?
A.
Data is redacted for the EMP.SAL column only if the SCOTT session does not have the
MGR role set.
B.
Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C.
Data is never redacted for the EMP_V.SAL column.
D.
Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR
role set.
E.
Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have
the MGR role set.