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: Dec 06, 2025

Add To Cart

Question 1

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

A : CDB1, PDB$SEED, PDB1, and PDB2

B : PDB$SEED, PDB1, and PDB2 only

C : CDB1 and PDB$SEED only

D : CDB1, PDB1, and PDB2 only

E : CDB1, PDB$SEED, and PDB1 only

Answer: A

Question 2

Choose three. Which three are true about block media recovery?

A :

To use it, Flashback Database must be enabled.

B :

A block being recovered is not accessible.

C :

It cannot repair logical corruption.

D :

It can be performed on noncorrupt blocks.

E :

The target database for which one or more blocks are to be recovered must be in the OPEN state.

F :

The data file containing the block being recovered remains online.

Answer: B,C,F

Question 3

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A :

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B :

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME

C :

Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D :

The new extended data type capability must be enabled by running the utlrp.sql script

E :

The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Answer: A,B,E

Question 4

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A : Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B : A connection to an auxiliary instance is always required.

C : A subset of the target database can be duplicated.

D : A new DBID is always created for the duplicated database.

E : A connection to the recovery catalog instance is always required.

F : A backup of the target database is always required.

G : Duplication can be done by having the target database instance push copies to the auxiliary database instance.

H : A connection to the target database instance is always required.

Answer: A,B,C

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Dec 06, 2025

Add To Cart