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. Which three are true about upgrading an application in an application container?

A :

An application root clone gets created automatically.

B :

The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

C :

After an application upgrade, the application container-s PDBs remain synchronized with the existing application root.

D :

The upgrade must be performed when connected to CDB$ROOT.

E :

An application name and version number must be specified to upgrade the application.

F :

After an application upgrade, the application container-s PDBs are automatically synchronized with the application root clone.

Answer: A,C,E

Question 2

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.
COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A : It will return an error because creation of a local role is not allowed in CDB$ROOT.

B : ROLE1 will be created only in CDB$ROOT.

C : It will return an error because common roles must start with C##.

D : ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E : ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Answer: A

Question 3

You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

A : The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B : The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C : All archive logs created after this backup are kept for two years.

D : The SPFILE is included in the self-contaied archival backup.

E : The control file is included in the self-contained archival backup.

F : The restore point is a label for the system change number (SCN) before the archival backup was taken.

Answer: A,B,D

Question 4

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 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart