← Back to exam page

1z0-060 – Upgrade to Oracle Database 12c

Loading demo links...

Showing 7–9 of 15 questions

Question 7

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?

Both local and global partitioned B-tree Indexes are defined on the table.

A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

Minimal disruption to availability is required.

Which three statements are true about this requirement? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    The partitions can be moved online to new tablespaces.
  • ○

    Global indexes must be rebuilt manually after moving the partitions.
  • ○

    The partitions can be compressed in the same tablespaces.
  • ○

    The partitions can be compressed in the new tablespaces.
  • ○

    Local indexes must be rebuilt manually after moving the partitions.
Question 8

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).

The following are the possible steps to accomplish this task:

1. Place all the user-defined tablespace in read-only mode on the source database.

2. Upgrade the source database to a 12c version.

3. Create a new PDB in the target container database.

4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

5. Copy the associated data files and export the dump file to the desired location in the target database.

6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify the correct order of the required steps.

Select an option, then click Submit answer.

  • ○

    2, 1, 3, 4, 5, 6
  • ○

    1, 3, 4, 5, 6, 7
  • ○

    1, 4, 3, 5, 6, 7
  • ○

    2, 1, 3, 4, 5, 6, 7
  • ○

    1, 5, 6, 4, 3, 2
Question 9

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.

How would you guarantee that the blocks for the table never age out?

Select an option, then click Submit answer.

  • ○

    Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
  • ○

    Increase the database buffer cache size.
  • ○

    Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
  • ○

    Configure Automata Shared Memory Management.
  • ○

    Configure Automatic Memory Management-