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: Apr 02, 2026

Add To Cart

Question 1

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 2

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

A : 2,4,5,6

B : 1,2,3,4,5,6

C : 1,2,4,5

D : 2,4,5

E : 1,3,4,5

Answer: D

Question 3

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A : The number of table rows is considered when evaluating the cost of accessing a table using an index.

B : Index balanced B*Tree height is considered when evaluating the cost of using an index.

C : The Statistics Advisor can help recommend the best way to gather statistics.

D : Statistics collected using DBMS_STATS always yield the best optimizer result.

E : The Statistics Advisor generates actions for all recommendations.

Answer: B,C

Question 4

Choose two. Which two are true about various Oracle security and auditing capabilities?

A : Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B : Application-common TSDP policies are always container specific.

C : Application-common OLS policies can be created only if all the PDBs in the application container are closed.

D : Unified auditing can be automatically synchronized to all application PDBs in an application container.

E : Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Answer: A,D

Question 5

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 02, 2026

Add To Cart