← Back to exam page

1z0-062 – Oracle Database 12c: Installation and Administration

Loading demo links...

Showing 13–15 of 20 questions

Question 13

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).

The characteristics of the non-CDB are as follows:

– Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit

– Character set: AL32UTF8

– National character set: AL16UTF16

– O/S: Oracle Linux 6 64-bit

The characteristics of the CDB are as follows:

– Version: Oracle Database 12c Release 1 64-bit

– Character Set: AL32UTF8

– National character set: AL16UTF16– O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

Select an option, then click Submit answer.

  • ○

    Transportable database
  • ○

    Transportable tablespace
  • ○

    Data Pump full export/import
  • ○

    The DBMS_PDB package
  • ○

    RMAN
Question 14

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

Select an option, then click Submit answer.

  • ○

    Only SGA components are sized automatically.
  • ○

    Memory is dynamically re-allocated between the SGA and PGA as needed.
  • ○

    The size of the PGA cannot grow automatically beyond 500 MB.
  • ○

    The value of the MEMORY_TARGET parameter cannot be changed dynamically.
Question 15

Examine the query and its output:

What might have caused three of the alerts to disappear?

Select an option, then click Submit answer.

  • ○

    The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
  • ○

    An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
  • ○

    An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
  • ○

    The database instance was restarted before the execution of the second query.