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: Mar 11, 2026

Add To Cart

Question 1

Choose three. Which three are true about a whole database backup?

A :

It can be created only by using RMAN.

B :

It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C :

It can be consistent.

D :

Â It is the only possible backup type for a database in NOARCHIVELOG mode.

E :

It can consist of either backup sets or image copies. F) It can be inconsistent.

Answer: C,D,E

Question 2

Choose the best answer. Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

A : 1,3,5, 6, 9

B : 1,3,5, 7, 10

C : 1,2, 5, 7,4, 10

D : 1,3, 5, 6, 10

E : 1,3,5, 6, 10

F : 1,3,5,8, 6, 10

Answer: B

Question 3

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 4

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

A : PDB2 will be opened READ WRITE.

B : PDB1 will be opened READ WRITE.

C : PDB1 will be MOUNTED.

D : PDB$SEED will be opened READ ONLY.

E : PDB$SEED will be MOUNTED

F : PDB2 will be MOUNTED.

Answer: A,B,D

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Mar 11, 2026

Add To Cart