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

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.
  
  

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.
  
  

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.
  
  

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
  
  

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.
  
  

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
  
  

Select an option, then click Submit answer.

• ○

  OSASM

• ○

  OSKMDBA

• ○

  OSDBA

• ○

  OSOPER

• ○

  OSRACDBA
  
  

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
  
  

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.
  
  

Select an option, then click Submit answer.

• ○

  FLASHBACK TRANSACTION

• ○

  FLASHBACK VERSION QUERY

• ○

  FLASHBACK DATA ARCHIVE

• ○

  FLASHBACK TABLE

• ○

  FLASHBACK DATABASE