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 17, 2025

Add To Cart

Question 1

Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully: Which two are true? (Choose two.)

A : Uncommitted transactions in PDB1 have been rolled back.

B : PDB1 is closed.

C : Uncommitted transactions in CDB1 and PDB1 have been rolled back.

D : CDB1 is shut down.

E : CDB1 is in MOUNT state

Answer: A,B

Question 2

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A :

A non-CDB can be cloned into a PDB.

B :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C :

Only one PDB can be cloned at a time.

D :

Two or more PDBs can be cloned with the same command.

E :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F :

The target and auxiliary instance passwords must be the same.

Answer: A,B,C

Question 3

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 4

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

A : when free space in a dictionary managed tablespace falls below a specified percentage

B : when free space in a locally managed tablespace falls below a specified percentage

C : when the total number of locked user account exceeds a specific value

D : when the number of logons per second exceeds a specific value

E : when a resumable statement is suspended

F : when the total number of logons exceeds a specific value

Answer: B,C,D

Question 5

choose two Which two statements are true about encrypted backups performed by using RMAN?

A : Transparent encryption of backups uses an encryption wallet.

B : Image copy backups can be created by using password encryption.

C : A password encryption of backups uses the password while creating and restoring backups.

D : Encrypted backups can only be written to disk.

E : A database uses the same encryption key for every encrypted backup.

Answer: A,C

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart