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

Add To Cart

Question 1

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 2

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 3

Choose three. Which three are true about a container database (CDB)?

A : It can be created from a non-CDB.

B : It can contain only one PDB$SEED, which is created when the CDB is created.

C : It can have local users with the same name in different PDBs.

D : It can contain only one Application Container seed, which is created when the Application Container is created.

E : It can be created by cloning an existing CDB.

F : It can have any number of pluggable databases (PDBs) limited only by space availability.

G : It contains predefined common roles in both the root and the seed.

Answer: A,B

Question 4

Choose three. Which three are true about the Oracle Optimizer?

A : It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B : It obeys all hints.

C : It considers object statistics when generating execution plans for SQL statements.

D : It updates stale object statistics in the Data Dictionary.

E : It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

F : It can re-optimize execution plans after previous executions detect suboptimal plans.

Answer: A,D

Question 5

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A : Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces

B : The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C : SPFILE backups can be created while connected to an application root PDB.

D : The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

E : The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 14, 2026

Add To Cart