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: Sep 15, 2026

Add To Cart

Question 1

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A : After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

B : Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT

C : After the change, only one undo tablespace can exist in CDB$ROOT.

D : After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E : Undo tablespaces existing in PDBs must be dropped before the change.

F : After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Answer: A,B

Question 2

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 3

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A : It analyzes a period of time corresponding to the 12 hours of activity.

B : It runs automatically after each AWR snapshot.

C : A DBA can run it manually.

D : Results are written to the alert log.

E : It analyzes a period of time corresponding to the last day of activity.

Answer: B,C

Question 4

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 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: Sep 15, 2026

Add To Cart