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

Add To Cart

Question 1

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 2

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

Question 3

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 4

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A : After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

B : Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT

C : After the change, only one undo tablespace can exist in CDB$ROOT.

D : After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E : Undo tablespaces existing in PDBs must be dropped before the change.

F : After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Answer: A,B

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Apr 22, 2026

Add To Cart