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: Jan 12, 2026

Add To Cart

Question 1

Which two are true about instance recovery? (Choose two.)

A : It is not possible if an archived log is missing.

B : It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

C : Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

D : It is performed by the Recovery Writer (RVWR) background process.

E : Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

F : It is performed automatically while the database remains in MOUNT state. Then the database is opened.

Answer: A,C

Question 2

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 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 two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A : It analyzes a period of time corresponding to the 12 hours of activity.

B : It runs automatically after each AWR snapshot.

C : A DBA can run it manually.

D : Results are written to the alert log.

E : It analyzes a period of time corresponding to the last day of activity.

Answer: B,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: Jan 12, 2026

Add To Cart