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: Mar 11, 2026

Add To Cart

Question 1

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?

A : restore and recover database

B : flashback transaction

C : flashback database

D : flashback table and transaction

E : flashback table

Answer: C

Question 2

Choose two. Which two are true about an RPM-based Oracle Database installation?

A : It includes the Oracle Preinstallation RPM.

B : From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

C : It requires an Unbreakable Linux Network (ULN) subscription.

D : It performs a software-only Oracle Database installation.

E : It uses a service configuration script to create a single-instance database as part of the installation.

Answer: B,D

Question 3

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

A : By default, AWR snapshots are taken every 60 minutes.

B : Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

C : By default, AWR snapshots are retained for 7 days.

D : The taking of AWR snapshots can be disabled.

E : AWR data is stored in the SYSTEM tablespace.

Answer: A,B,D

Question 4

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A : PDB1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : PDB1 and PDB2 are in READ ONLY state.

D : CDB$ROOT is in MOUNT state.

E : PDB$SEED is in READ ONLY state.

Answer: A,D

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Mar 11, 2026

Add To Cart