Free Oracle 1Z0-083 Exam Questions

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?

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

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A : FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B : FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C : FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D : FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E : FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F : FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer: A,B

Question 3

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

A : DBUA must be launched from the target Oracle Home.

B : Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

C : A whole database backup must exist before upgrade.

D : The Pre-Upgrade Information Tool script is executed by DBUA.

E : All pluggable databases are automatically upgraded as part of a container database upgrade.

F : The database must be opened in read-only mode.

Answer: A,D

Question 4

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A : Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D : Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E : Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: A,C

Question 5

Which two are true about RMAN duplexed backup sets? (Choose two.)

A : A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

B : A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

C : A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

D : A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

E : A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

F : A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Answer: B,D