Oracle Database Administration II 1z0-083 Question # 51 Topic 6 Discussion

Oracle Database Administration II 1z0-083 Question # 51 Topic 6 Discussion

1z0-083 Exam Topic 6 Question 51 Discussion:
Question #: 51
Topic #: 6

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') END; All users have their default set of system privileges. For which three situations will data not be redacted?


A.

SYSsessions,regardlessoftherolesthataresetinthesession


B.

SYSTEMsessions,regardlessoftherolesthataresetinthesession


C.

SCOTT sessions, only if the MGR role is set in the session


D.

SCOTT sessions, only if the MGR role is granted to SCOTT


E.

SCOTTsessions,becauseheistheownerofthetable


F.

SYSTEM session, only if the MGR role is set in the session


Get Premium 1z0-083 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.