Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.

Which action could help in the performance management of these regressed SQL statements?

BEGIN

      DBMS_REDACT.ADD_POLICY(

            Object_schema => 'SCOTT',

            Object_name => 'EMP',

            Column_name => 'SAL',

            Policy_name => 'SCOTT_EMP',

            Function_type => DBMS_REDACT.FULL,

            Expression => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'')

                                                                                                            = ''FALSE''');

END;

BEGIN

      DBMS_REDACT.ADD_POLICY(

            Object_schema => 'SCOTT',

            Object_name => 'EMP_VW',

            Column_name => 'SAL',

            Policy_name => 'SCOTT_EMP_VW',

            Function_type => DBMS_REDACT.NONE,

            Expression => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'')

                                                                                                            = ''FALSE''');

END;

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?

BEGIN

      DBMS_REDACT.ADD_POLICY(

            Object_schema => 'SCOTT',

            Object_name => 'EMP',

            Column_name => 'SAL',

            Policy_name => 'SCOTT_EMP',

            Function_type => DBMS_REDACT.FULL,

            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?

You queried the table twice.

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

（含图）

（含图）

Which is guaranteed to be true concerning the redaction policy?