Question 1

You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; 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'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); 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?

Options :

A : DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

B : DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C : Data is never redacted for the EMP_VW.SAL column.

D : Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E : Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct

Answer: A,C

Question 2

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options :

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Question 3

choose two Which two are true about RMAN image copies?

Options :

A : They can only be written to disk.

B : They can be encrypted using Transparent Data Encryption (TDE).

C : They can be used as a level 0 incremental backup.

D : They can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 4

Which three are true about opatch auto? (Choose three.)

Options :

A : It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B : It must be invoked by a user with root user privileges.

C : Patches are applied via opatchauto.

D : Users must always input patch plans to opatchauto.

E : It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F : It applies patches in nonrolling mode by default.

G : It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: A,B

Question 5

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

Options :

A : Data Recovery Advisor can proactively check for failures.

B : Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

C : ata Recovery Advisor can be used if a database is in the NOMOUNT state.

D : A failure can be closed only if the database is in MOUNT state.

E : Data Recovery Advisor can be used if a database is closed.

Answer: A,B