Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart

Question 1

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

A : to allow database duplication without a connection to the target instance

B : to store backup metadata that would cause the controlfile to become too large.

C : to store backups that would cause the controlfile to become too large

D : to report on the database schema at an earlier point in time.

E : to allow database duplication without a connection to the auxiliary instance.

Answer: A,B,D

Question 2

choose three Which three are true about unified auditing in full mode?

A : The unified audit trail is written to a read-only table.

B : The unified audit trail is written to a read-only external file.

C : Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D : Audit records are created for SYS.

E : Audit records are created for non-sys users.

Answer: A,D

Question 3

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

A : It fails because Data Pump cannot be container.

B : It creates a full export of the root

C : It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Answer: A

Question 4

Choose three. Which three are true about the FLASHBACK DATABASE feature?

A : FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B : It requires that the target database be in ARCHIVELOG mode.

C : FLASHBACK LOGS are archived after a log switch.

D : A database can be flashed back using SQL*PLUS.

E : It always generates REDO and UNDO.

F : Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

Answer: A,B,D

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart