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

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 2

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

A :

They are never considered obsolete by RMAN.

B :

They can optionally be written to a fast recovery area (FRA).

C :

Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D :

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E :

The SPFILE is included in the archival backup.

F :

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 3

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 4

Which three are true about the SQL Tuning Advisor? (Choose three.)

A : It checks each query being analyzed for stale statistics.

B : It checks each query being analyzed for missing statistics.

C : It only recommends syntactic changes to SQL statements.

D : It can recommend semantic changes to SQL statements.

E : It considers all SQL statements being analyzed by the advisor task as a group.

F : It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Answer: A,B,D

Question 5

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A : AWR snapshots can be created in CDB$ROOT.

B : ADDM can run in a nonroot container.

C : AWR reports can be generated while connected to any container.

D : All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E : AWR snapshots can be created in a PDB.

F : No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Answer: A,D

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart