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

Add To Cart

Question 1

Choose three. Which three are true about the Oracle Optimizer?

A : It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B : It obeys all hints.

C : It considers object statistics when generating execution plans for SQL statements.

D : It updates stale object statistics in the Data Dictionary.

E : It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

F : It can re-optimize execution plans after previous executions detect suboptimal plans.

Answer: A,D

Question 2

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

A : It is enabled for all users having SELECT privilege on SH.SALES.

B : Only successful queries of SH.SALES are written to the audit trail.

C : It is only enabled for user SH.

D : Audit records are always stored in an external audit file.

Answer: A

Question 3

Which three statements are true about Flashback Data Archive?

A : To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

B : To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

C : While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

D : A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

E : Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Answer: A,C,D

Question 4

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

A : It fails because Data Pump cannot be container.

B : It creates a full export of the root

C : It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Answer: A

Question 5

Choose three. Which three activities are possible for PDBs?

A :

converting an application seed to an application PDB

B :

converting a regular PDB to an application PDB

C :

converting an application PDB to an application root

D :

copying an application container into another application container in the same CDB

E :

copying an application container into another application container in a different CDB

F :

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Answer: B,D,F

Page: 1 / 57

Total 285 Questions | Updated On: Feb 11, 2026

Add To Cart