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 three are true about Automatic Workload Repository (AWR) snapshots?

A :

They are generated if STATISTICS_LEVEL is set to TYPICAL.

B :

They are always created manually.

C :

They are always created automatically.

D :

They are generated if STATISTICS_LEVEL is set to BASIC.

E :

They are generated if STATISTICS_LEVEL is set to ALL.

F :

They can be retained forever.

Answer: A,E,F

Question 2

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 3

Choose three. Which three are true about recovering tables using RMAN?

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

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

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

A : Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

B : Add only the CREATE_FILE_DEST clause to the statement.

C : Set only the PDB_FILE_NAME_CONVERT parameter.

D : Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E : Enable only OMF.

F : Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

Answer: A,B,C

Page: 1 / 57

Total 285 Questions | Updated On: Feb 11, 2026

Add To Cart