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.SCOTT sessions, only if the MGR role is set in the session
• B.SYSsessions,regardlessoftherolesthataresetinthesession
• C.SCOTT sessions, only if the MGR role is granted to SCOTT
• D.SYSTEM session, only if the MGR role is set in the session
• E.SYSTEMsessions,regardlessoftherolesthataresetinthesession
• F.SCOTTsessions,becauseheistheownerofthetable

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

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.
How do you achieve this?

• A.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
• D.This cannot be done due to the lack of a clean restore point.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A.By default, the transported database will use Oracle Managed Files (OMF)
• B.Data files can be converted on the destination system.
• C.Data files can be converted on the source system.
• D.A new DBID is automatically created for the transported database.
• E.Databases can be transported between systems with different endian formats.
• F.The password file is automatically converted by RMAN.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

• A.CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
• B.CDB1_TAB only
• C.CDB1_TAB and APP_ROOT_TAB
• D.CDB1_TAB and APP_PDB1_TAB
• E.none of the tables, because all three tables will be dropped

Comment: *

Name: *

Email: *

Verification: *

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A.All archive logs created after this backup are kept for two years.
• B.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
• C.The SPFILEis included in the self-contaied archival backup.
• D.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• E.The control file is included in the self-contained archival backup.
• F.The restore point is a label for the system change number (SCN) before the archival backup was taken.

Comment: *

Name: *

Email: *

Verification: *