OCP考试083

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.

SQL>select pdb name,name,pdb restore point,clean pdb restore point

2from v$restore_point natural join dba pdbs;

PDB_NAME      NAME          PDB_RESTORE_POINT     CLEAN_PDB_RESTORE_POINT

----------------------------------------------------------------------------

PDB1           R1                  YES                     NO

SQL> select property name, property_value

2 from database properties where property name like UNDOt';

PROPERTY_NAME                   PROPERTY_VALUE

--------------------------------------------------

LOCAL UNDO ENABLED              FALSE

How do you achieve this?

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?