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: Nov 26, 2025

Add To Cart

Question 1

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

Question 2

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 3

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

A :

They are never considered obsolete by RMAN.

B :

They can optionally be written to a fast recovery area (FRA).

C :

Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D :

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E :

The SPFILE is included in the archival backup.

F :

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 4

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 5

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

A : an operating system user to own this installation

B : the Oracle Inventory group oinstall

C : an operating system account called grid

D : a group called dba

E : the installation of Oracle ASMLIB

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Nov 26, 2025

Add To Cart