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: Nov 26, 2025

Add To Cart

Question 1

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

A : orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B : root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C : The sudo password can be specified in a response file.

D : root.sh can be executed automatically by the Database installer only by using sudo credentials

E : The sudo password must be specified in a response file.

F : The root password cannot be specified in a response file.

Answer: A

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

Choose three. Which three are true in Oracle 19c and later releases?

A : Tablespaces always remain in read/write mode during transportable tablespace operations.

B : Tablespaces never remain in read/write mode during transportable tablespace operations.

C : A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D : Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E : A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F : An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Answer: A,B

Question 4

Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path destinationhome Oracle_home_path For which two purposes can you use this command?

A : to switch to a patched Oracle Database home

B : to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C : to move an Oracle Database to the centralized Rapid Home Provisioning server

D : to switch back to the previous Oracle home as part of a rollback operation

E : to switch to a read-only Oracle home

Answer: A,B

Question 5

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

A : Create the PDB1 application PDB and synchronize it with poB$SEED.

B : Create the PDB1 application PDB and synchronize it with HR_ROOT.

C : Create the PDB1 application PDB and install HR_APP in it.

D : Create an application seed, and install HR_APP in it.

E : Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Nov 26, 2025

Add To Cart