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 08, 2026

Add To Cart

Question 1

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

A : A PDB snapshot depends on an existing storage snapshot of the source PDB.

B : APDB snapshot can be a full copy of a source PDB.

C : A PDB snapshot can be a sparse copy of a source PDB

D : A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

E : A snapshot copy PDB can be a full copy of a source PDB

Answer: B,C

Question 2

Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path destinationhome Oracle_home_path For which two purposes can you use this command?

A : to switch to a patched Oracle Database home

B : to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C : to move an Oracle Database to the centralized Rapid Home Provisioning server

D : to switch back to the previous Oracle home as part of a rollback operation

E : to switch to a read-only Oracle home

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

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

A : CDB1 and CDB2 must be in shared undo mode.

B : A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C : All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D : Cloning HR_ROOT automatically clones HR_PDB1.

E : The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

Answer: A,D

Question 5

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A :

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B :

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME

C :

Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D :

The new extended data type capability must be enabled by running the utlrp.sql script

E :

The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Answer: A,B,E

Page: 1 / 57

Total 285 Questions | Updated On: Feb 08, 2026

Add To Cart