← Back to exam page

1z0-083 – Oracle Database Administration II

Loading demo links...

Showing 4–6 of 10 questions

Question 4

A database is configured in ARCHIVELOG mode.

A full RMAN backup exists but no control file backup to trace has been taken.

A media failure has occurred.

In which two scenarios is incomplete recovery required? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    after losing a SYSAUX tablespace data file
  • ○

    after losing all members of an INACTIVE online redo log group
  • ○

    after losing all members of the CURRENT online redo log group
  • ○

    after losing all copies of the control file
  • ○

    after losing an UNDO tablespace that is in use
Question 5

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    A PDB snapshot can be a sparse copy of a source PDB.
  • ○

    A PDB snapshot depends on an existing storage snapshot of the source PDB.
  • ○

    A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
  • ○

    A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
  • ○

    A PDB snapshot can be a full copy of a source PDB.
  • ○

    A snapshot copy PDB can be a full copy of a source PDB.
  • ○

    A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
Question 6

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.

Examine these steps:

1. Install the SALES_APP application, including the common tables, in the application root.

2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8. Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

Select an option, then click Submit answer.

  • ○

    3, 4, 1, 6, 8
  • ○

    2, 5, 6
  • ○

    1, 5, 6
  • ○

    1, 3, 5, 6, 7
  • ○

    1, 3, 5, 7