Oracle
1Z0-067 · Question #202
1Z0-067 Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
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
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.