1. Home
  2. Oracle
  3. 1Z0-083

Oracle Database Administration II

Exam Details

  • Exam Code
    :1Z0-083
  • Exam Name
    :Oracle Database Administration II
  • Certification
    :Oracle Certifications
  • Vendor
    :Oracle
  • Total Questions
    :273 Q&As
  • Last Updated
    :Mar 26, 2025

Oracle Oracle Certifications 1Z0-083 Questions & Answers

  • Question 21:

    Which two are true about RMAN backups when using a media manager? (Choose two.)

    A. A media manager always writes RMAN requested backups to tape.

    B. By default, a request for a proxy copy may result in a backup set being created.

    C. A media manager is required to create RMAN proxy copies.

    D. A media manager is required to create RMAN image copies.

    E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

  • Question 22:

    Examine this configuration:

    1.

    CDB1 is a container database.

    2.

    APP_ROOT is an application root in CDB1.

    3.

    APP_PDB1 is an application PDB in APP_ROOT.

    4.

    FLASHBACK DATABASE is ON.

    You execute these commands:

    Which table or set of tables will exist after the Flashback operation has completed?

    A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

    B. CDB1_TAB and APP_PDB1_TAB

    C. none of the tables, because all three tables will be dropped

    D. CDB1_TAB only

    E. CDB1_TAB and APP_ROOT_TAB

  • Question 23:

    Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

    A. A lost SPFILE can be recovered from memory using SQL*PLUS.

    B. A lost password file can be re-created with SQL*PLUS.

    C. A lost TEMPFILE must always be re-created manually.

    D. A lost password file can be manually re-created with the orapwd utility.

    E. A lost PFILE can be re-created alert.log using SQL*PLUS.

    F. A lost index tablespace can be re-created without performing any recovery.

  • Question 24:

    In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

    A. poorly written SQL

    B. the number of tablespaces containing tables updated by a transaction

    C. poorly trained users who do not commit transactions

    D. the number of data files containing extents belonging to tables updated by a transaction

    E. issuing multiple savepoints during a transaction

  • Question 25:

    You issued this command:

    RMAN> BACKUP RECOVERY AREA FORCE;

    Which three are true? (Choose three.)

    A. All files in the current FRA that have been backed up already, are backed up.

    B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

    C. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

    D. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.

    E. All files in any previous FRA that have not yet been backed up, are backed up.

    F. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.

    G. All files in any previous FRA that have been backed up already, are backed up.

  • Question 26:

    Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)

    A. It can be used only on nodes with Oracle Grid Infrastructure installed.

    B. It can be used to patch existing Oracle software installations.

    C. It can be used to create templates of Oracle homes as gold images of only Oracle databases.

    D. It can be used to deploy new homes without disrupting active databases.

    E. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

    F. It can be used to upgrade only single-instance databases running on Oracle Restart.

  • Question 27:

    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? (Choose two.)

    A. Create an application seed, and install HR_APP in it.

    B. Create the PDB1 application PDB and install HR_APP in it.

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

    D. Create the PBD1 application PDB and synchronize it with HR_ROOT.

    E. Create the PBD1 application PDB and synchronize it with PDB$SEED.

  • Question 28:

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

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

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

    C. It performs a software-only Oracle Database installation.

    D. It includes the Oracle Preinstallation RPM.

    E. It requires an Unbreakable Linux Network (ULN) subscription.

  • Question 29:

    Which three are true about a whole database backup? (Choose three.)

    A. It can consist of either backup sets or image copies.

    B. It is the only possible backup type for a database in NOARCHIVELOG mode.

    C. It can be consistent.

    D. It can be created only by using RMAN.

    E. It can be inconsistent.

    F. It always includes all data files, the current control file, the server parameter file, and archived redo logs.

  • Question 30:

    Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

    A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

    B. Space might be reclaimed proactively before space pressure occurs.

    C. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

    D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

    E. Space is always reclaimed proactively before space pressure occurs.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-083 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.