Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1z0-083

Oracle 1z0-083 Exam (page: 1)
Oracle Database Administration II
Updated on: 25-Aug-2025

Viewing Page 1 of 58
1z0-083 PDF 286 Questions

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:

Install the SALES_APP application, inducing the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

  1. 1,3,5,7
  2. 2,5,6
  3. 1,5,6
  4. 3,4,1.6,8
  5. 1,3,5,6,7

Answer(s): C



A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

  1. CDB2 must be in shared UNDO mode only.
  2. CDB2 must be in archivelog mode.
  3. CDB1 must be in archivelog mode.
  4. CDB1 and CDB2 must both be in local UNDO mode.
  5. CDB1 must be in shared UNDO mode only. A container database, CDB1, contains a pluggable database PDB1.
  6. CDB1 and CDB2 must be in shared UNDO mode.

Answer(s): B,C,D



Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

  1. A PDB snapshot depends on an existing storage snapshot of the source PDB.
  2. APDB snapshot can be a full copy of a source PD
  3. A PDB snapshot can be a sparse copy of a source PDB
  4. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
  5. A snapshot copy PDB can be a full copy of a source PDB

Answer(s): B,C



Which two are true about creating RMAN backups for an Oracle container database?

  1. Online Redo Log backups can be created while connected to CDB$ROOT
  2. Control file backups can be created while connected to CDB$ROOT.
  3. The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.
  4. Archived Redo Log backups can be created while connected to PDB
  5. Control file backups can not be created while connected to a PDB

Answer(s): A,B



Which three are true about Automatic Workload Repository (AWR) snapshots?

  1. They can be retained forever.
  2. They are always created automatically.
  3. They are always created manually.
  4. They are generated if STATISTICS LEVEL is set to TYPICAL.
  5. They are generated if STATISTICS LEVEL is set to BASIC.
  6. They are generated if STATISTICS LEVEL is set to ALL.

Answer(s): B,D,F



Viewing Page 1 of 58



Share your comments for Oracle 1z0-083 exam with other users:

Blessious Phiri 8/13/2023 10:32:00 AM

very explainable
Anonymous


Blessious Phiri 8/15/2023 3:38:00 PM

excellent topics covered
Anonymous


Blessious Phiri 8/12/2023 11:56:00 AM

its getting more technical
Anonymous


Blessious Phiri 8/15/2023 1:56:00 PM

asm management configuration is about storage
Anonymous


Blessious Phiri 8/14/2023 9:53:00 AM

cbd and pdb are key to the database
SOUTH AFRICA


Blessious Phiri 8/13/2023 11:58:00 AM

becoming interesting on the logical part of the cdbs and pdbs
Anonymous


Blessious Phiri 8/13/2023 10:26:00 AM

admin ii is real technical stuff
Anonymous


Blessious Phiri 8/12/2023 2:19:00 PM

so challenging
Anonymous


Blessious Phiri 8/13/2023 8:37:00 AM

making progress
Anonymous


Blessious Phiri 8/15/2023 3:19:00 PM

oracle 19c is complex db
Anonymous


Blessious Phiri 8/13/2023 9:35:00 AM

rman is one good recovery technology
Anonymous


Blessious Phiri 8/14/2023 3:49:00 PM

expository experience
Anonymous


Blessious Phiri 8/15/2023 3:31:00 PM

these questions are a great eye opener
Anonymous


Blessious Phiri 8/15/2023 2:18:00 PM

pdb and cdb are critical to the database
Anonymous


Blessious Phiri 8/13/2023 3:10:00 PM

control file is the heart of rman backup
Anonymous


Blessious Phiri 8/12/2023 11:47:00 AM

the exams are giving me an eye opener
Anonymous


Blessious Phiri 8/15/2023 2:02:00 PM

dbua is used for upgrading oracle database
Anonymous


Blessious Phiri 8/15/2023 4:08:00 PM

its giving best technical knowledge
Anonymous