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. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

A : when free space in a dictionary managed tablespace falls below a specified percentage

B : when free space in a locally managed tablespace falls below a specified percentage

C : when the total number of locked user account exceeds a specific value

D : when the number of logons per second exceeds a specific value

E : when a resumable statement is suspended

F : when the total number of logons exceeds a specific value

Answer: B,C,D

Question 2

Which three are true about opatch auto? (Choose three.)

A : It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B : It must be invoked by a user with root user privileges.

C : Patches are applied via opatchauto.

D : Users must always input patch plans to opatchauto.

E : It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F : It applies patches in nonrolling mode by default.

G : It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: A,B

Question 3

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

A : the data dictionary in CDB$ROOT

B : the log writer process (LGWR)

C : SYSAUX tablespaces

D : temporary tablespaces

E : the Process Monitor Process (PMON)

F : undo tablespaces

Answer: A,B

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 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