Oracle
1Z0-067 · Question #202
A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( OBJECT_SCHEMA => SCOTT', OBJECT_NAME => EMP', POLICY_NAME => SCOTT_EMP', COLUMN_NAME => SAL'…
The correct answer is B. SCOTT sessions, only if the MGR role is granted to SCOTT C. SCOTT sessions, only if the MGR role is set in the session D. SYS sessions, regardless of the roles that are set in the session. See the full explanation below for the reasoning.
Question
A redaction policy was added to the SAL column of the SCOTT.EMP table:
BEGIN DBMS_REDACT.ADD_POLICY( OBJECT_SCHEMA => SCOTT', OBJECT_NAME => EMP', POLICY_NAME => SCOTT_EMP', COLUMN_NAME => SAL', EXPRESSION => `SYS_CONTEXT (SYS_SESSION_ROLES'', MGR'') = ``FALSE'''); END; / All users have their default set of system privileges. For which three situations will data not be redacted? (Choose three.)
Options
- ASCOTT sessions, because he is the owner of the table
- BSCOTT sessions, only if the MGR role is granted to SCOTT
- CSCOTT sessions, only if the MGR role is set in the session
- DSYS sessions, regardless of the roles that are set in the session
- ESYSTEM sessions, regardless of the roles that are set in the session
How the community answered
(41 responses)- A15% (6)
- B78% (32)
- E7% (3)
Community Discussion
No community discussion yet for this question.