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

Add To Cart

Question 1

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

A :

It has the same common users defined as does CDB1.

B :

It has only local roles.

C :

It has the same number of roles as CDB1.

D :

Service PDB1 is created for remote logins to PDB1.

E :

It is in mount state after creation.

F :

It has no local users.

Answer: A,B,D

Question 2

Which two are true about creating RMAN backups for an Oracle container database?

A : Online Redo Log backups can be created while connected to CDB$ROOT

B : Control file backups can be created while connected to CDB$ROOT.

C : The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

D : Archived Redo Log backups can be created while connected to PDB

E : Control file backups can not be created while connected to a PDB

Answer: A,B

Question 3

Choose three. Which three activities are possible for PDBs?

A :

converting an application seed to an application PDB

B :

converting a regular PDB to an application PDB

C :

converting an application PDB to an application root

D :

copying an application container into another application container in the same CDB

E :

copying an application container into another application container in a different CDB

F :

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Answer: B,D,F

Question 4

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A : The number of table rows is considered when evaluating the cost of accessing a table using an index.

B : Index balanced B*Tree height is considered when evaluating the cost of using an index.

C : The Statistics Advisor can help recommend the best way to gather statistics.

D : Statistics collected using DBMS_STATS always yield the best optimizer result.

E : The Statistics Advisor generates actions for all recommendations.

Answer: B,C

Question 5

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Jan 04, 2026

Add To Cart