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: Apr 28, 2026

Add To Cart

Question 1

Choose two. Which two are true about an RPM-based Oracle Database installation?

A : It includes the Oracle Preinstallation RPM.

B : From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

C : It requires an Unbreakable Linux Network (ULN) subscription.

D : It performs a software-only Oracle Database installation.

E : It uses a service configuration script to create a single-instance database as part of the installation.

Answer: B,D

Question 2

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A : PDB1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : PDB1 and PDB2 are in READ ONLY state.

D : CDB$ROOT is in MOUNT state.

E : PDB$SEED is in READ ONLY state.

Answer: A,D

Question 3

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 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

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A : A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B : A PDB Lockdown profile can be created in an application root.

C : A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D : A PDB Lockdown profile can be created in a regular PDB.

E : A PDB Lockdown profile can be created in CDB$ROOT .

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 28, 2026

Add To Cart