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? (Choose two.)
You Execute The 1 (37.71 KiB) Viewed 174 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!