1Z0-083 Web TestEngine demo

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?

Select all that apply.

• A

  DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

• B

  DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

• C

  Data is never redacted for the EMP_VW.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. Correct