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: Oct 27, 2026

Add To Cart

Question 1

You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

A : The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B : The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C : All archive logs created after this backup are kept for two years.

D : The SPFILE is included in the self-contaied archival backup.

E : The control file is included in the self-contained archival backup.

F : The restore point is a label for the system change number (SCN) before the archival backup was taken.

Answer: A,B,D

Question 2

Which three are true about the SQL Tuning Advisor? (Choose three.)

A : It checks each query being analyzed for stale statistics.

B : It checks each query being analyzed for missing statistics.

C : It only recommends syntactic changes to SQL statements.

D : It can recommend semantic changes to SQL statements.

E : It considers all SQL statements being analyzed by the advisor task as a group.

F : It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Answer: A,B,D

Question 3

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

A : the data dictionary in CDB$ROOT

B : the log writer process (LGWR)

C : SYSAUX tablespaces

D : temporary tablespaces

E : the Process Monitor Process (PMON)

F : undo tablespaces

Answer: A,B

Question 4

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

A : CDB1 and CDB2 must be in shared undo mode.

B : A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C : All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D : Cloning HR_ROOT automatically clones HR_PDB1.

E : The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

Answer: A,D

Question 5

Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl'is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?

A : It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B : It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

C : It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

D : It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

E : It will fail because there is no autobackup of the controlfiles.

Answer: C

Page: 1 / 57

Total 285 Questions | Updated On: Oct 27, 2026

Add To Cart