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: Dec 17, 2025

Add To Cart

Question 1

Choose three. Which three are true in Oracle 19c and later releases?

A : Tablespaces always remain in read/write mode during transportable tablespace operations.

B : Tablespaces never remain in read/write mode during transportable tablespace operations.

C : A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D : Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E : A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F : An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Answer: A,B

Question 2

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

A : The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

B : The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C : The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog

D : The base catalog must be enabled for Virtual Private Catalog use.

E : The target PDB must be registered in a Virtual Private Catalog.

F : The target PDB must be registered in a base catalog.

Answer: A,C,D

Question 3

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

A : It recompiles all stored PL/SQL code by using utlrp.sql.

B : It empties the RECYCLE BIN.

C : It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

D : It sets all user tablespaces to ''read-only'' before starting the upgrade.

E : It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

F : It increases tablespace size, if required, to meet upgrade requirements.

Answer: A,B,C

Question 4

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 5

Identify three benefits of Unified Auditing.

A : Decreased use ofstorage to store audit trail rowsin the database.

B : It improves overall auditing performance.

C : It guarantees zero-loss auditing.

D : The audit trail cannot be easily modified because it is read-only.

E : It automatically audits Recovery Manager (RMAN) events.

Answer: A,B,D

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart