Free 1z0-083 – Oracle Database Administration II Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

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

Select all that apply, then click Submit answer.

  • ○

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

  • ○

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

  • ○

    It performs a software-only Oracle Database installation.

  • ○

    It includes the Oracle Preinstallation RPM.

  • ○

    It requires an Unbreakable Linux Network (ULN) subscription.

Question 2

Which two are true about RMAN encryption? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    RMAN encryption keys are stored in a database keystore.

  • ○

    RMAN can encrypt the Oracle Database password file.

  • ○

    Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

  • ○

    The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

  • ○

    Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Question 3

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    A PDB-level resource plan can limit session PGA memory.

  • ○

    A CDB-level resource plan can limit PDB CPU utilization.

  • ○

    A CDB-level resource plan can limit session CPU utilization.

  • ○

    PDB-level resource plans can limit uncommitted UNDO per consumer group.

  • ○

    A CDB-level resource plan can limit PDB UNDO use.

  • ○

    A CDB-level resource plan is mandatory when using PDB-level resource plans.