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 07, 2026

Add To Cart

Question 1

choose three Which three are true about unified auditing in full mode?

A : The unified audit trail is written to a read-only table.

B : The unified audit trail is written to a read-only external file.

C : Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D : Audit records are created for SYS.

E : Audit records are created for non-sys users.

Answer: A,D

Question 2

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

A :

It has the same common users defined as does CDB1.

B :

It has only local roles.

C :

It has the same number of roles as CDB1.

D :

Service PDB1 is created for remote logins to PDB1.

E :

It is in mount state after creation.

F :

It has no local users.

Answer: A,B,D

Question 3

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

A : cloning a remote container database in interactive mode

B : cloning a remote pluggable database in silent mode

C : relocating a remote pluggable database in interactive mode

D : relocating a remote container database in silent mode

E : cloning a remote container database in silent mode

F : relocating a remote pluggable database in silent mode

G : relocating a remote container database in interactive mode.

Answer: A,B

Question 4

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

A :

Integration with Third-Party Media Managers

B :

Use of SBT (Sun Business Talk) Interface

C :

Channel Allocation

D :

Requires Configuration

E :

Vendor-Specific Modules

Answer: A,D

Question 5

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A : AWR snapshots can be created in CDB$ROOT.

B : ADDM can run in a nonroot container.

C : AWR reports can be generated while connected to any container.

D : All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E : AWR snapshots can be created in a PDB.

F : No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Answer: A,D

Page: 1 / 57

Total 285 Questions | Updated On: Mar 07, 2026

Add To Cart