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: Nov 20, 2025

Add To Cart

Question 1

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

Question 2

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 3

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

A : By default, the transported database will use Oracle Managed Files (OMF)

B : Data files can be converted on the destination system.

C : Data files can be converted on the source system.

D : A new DBID is automatically created for the transported database.

E : Databases can be transported between systems with different endian formats.

F : The password file is automatically converted by RMAN.

Answer: A,B,C

Question 4

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 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Nov 20, 2025

Add To Cart