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

Add To Cart

Question 1

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

Question 2

Choose two. Which two are true about RMAN backups when using a media manager?

A : A media manager always writes RMAN requested backups to tape.

B : A media manager is required to create RMAN image copies.

C : A media manager is required to create RMAN proxy copies.

D : The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

E : By default, a request for a proxy copy may result in a backup set being created.

Answer: C,E

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

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

Add To Cart