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

Add To Cart

Question 1

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 2

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A : FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B : FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C : FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D : FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E : FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F : FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer: A,B

Question 3

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

A : CDB1, PDB$SEED, PDB1, and PDB2

B : PDB$SEED, PDB1, and PDB2 only

C : CDB1 and PDB$SEED only

D : CDB1, PDB1, and PDB2 only

E : CDB1, PDB$SEED, and PDB1 only

Answer: A

Question 4

Which two are true about common objects? (Choose two.)

A : They can be created only in CDB$ROOT.

B : They can be only metadata-linked in an application container.

C : They can exist in user-defined schemas only in application containers.

D : They can exist in CDB$ROOT and an application root.

E : They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Answer: D

Question 5

Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

A :

log writer performance

B :

database writer performance

C :

general operating system health

D :

SQL statements

E :

database instance memory management and sizes

Answer: C

Page: 1 / 57

Total 285 Questions | Updated On: Feb 11, 2026

Add To Cart