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

Which two are true about common objects? (Choose two.)

A : They can be created only in CDB$ROOT.

B : They can be only metadata-linked in an application container.

C : They can exist in user-defined schemas only in application containers.

D : They can exist in CDB$ROOT and an application root.

E : They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Answer: D

Question 2

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 3

Choose two. Which two are true about an RPM-based Oracle Database installation?

A : It includes the Oracle Preinstallation RPM.

B : From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

C : It requires an Unbreakable Linux Network (ULN) subscription.

D : It performs a software-only Oracle Database installation.

E : It uses a service configuration script to create a single-instance database as part of the installation.

Answer: B,D

Question 4

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 5

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

A : redo logs

B : control files

C : all data dictionary metadata

D : user-defined PL/SQL packages

E : temporary tablespaces

F : mandatory Oracle-supplied PL/SQL packages

G : undo tablespaces

Answer: A,B,C

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart