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 02, 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

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

Question 3

choose three Which three RMAN persistent settings can be set explicitly?

A : SPFILE backup duplexing

B : control file auto backup formats

C : archive log deletion policy

D : image copy duplexing

E : redo log backup duplexing

F : archive log backup duplexing

Answer: A,B,C

Question 4

choose three Which three are true about unified auditing in full mode?

A : The unified audit trail is written to a read-only table.

B : The unified audit trail is written to a read-only external file.

C : Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D : Audit records are created for SYS.

E : Audit records are created for non-sys users.

Answer: A,D

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Apr 02, 2026

Add To Cart