← Back to exam page

1z0-083 – Oracle Database Administration II

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Which operating system group is NOT needed to perform an Oracle Database installation?

Select an option, then click Submit answer.

  • ○

    OSASM
  • ○

    OSKMDBA
  • ○

    OSDBA
  • ○

    OSOPER
  • ○

    OSRACDBA
Question 8

Examine this configuration:

1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.

2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE

4. PDB2 is MOUNTED.

5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.

You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

Select an option, then click Submit answer.

  • ○

    CDB1, PDB$SEED, PDB1, and PDB2
  • ○

    PDB$SEED, PDB1, and PDB2 only
  • ○

    CDB1 and PDB$SEED only
  • ○

    CDB1, PDB1, and PDB2 only
  • ○

    CDB1, PDB$SEED, and PDB1 only
Question 9

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.

You want to recover PDB1 to Restore Point R1.

How do you achieve this?

Select an option, then click Submit answer.

  • ○

    Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
  • ○

    Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
  • ○

    Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
  • ○

    Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
  • ○

    This cannot be done due to the lack of a clean restore point.