← Back to exam page

1z0-063 – Oracle Database 12c: Advanced Administration

Loading demo links...

Showing 10–12 of 15 questions

Question 10

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

Select an option, then click Submit answer.

  • ○

    The minimum size for the standard buffer cache is 100 MB.
  • ○

    The maximum size for the standard buffer cache is 100 MB.
  • ○

    The minimum space guaranteed in the buffer cache for any server process is 100 MB.
  • ○

    The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
  • ○

    The minimum size for all buffer caches is 100 MB.
Question 11

Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

Select an option, then click Submit answer.

  • ○

    The script is executed and both DC1 and CH1 channels are used for script execution.
  • ○

    The execution of the script fails because multiple channels cannot exist simultaneously.
  • ○

    The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
  • ○

    The new channel, CH1, is ignored because a channel has been configured already.
Question 12

You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.

One of the data files is corrupted and the current online redo log file is lost because of a media failure.

You want to recover the data file.

Examine the steps involved in the recovery process:

1. Shut down the database instance.

2. Start up the database instance in nomount state.

3. Mount the database.

4. Take the data file offline.

5. Put the data file online.

6. Restore the control file.

7. Restore the database.

8. Restore the data file.

9. Open the database with the RESETLOGS option.

10. Recover the database with the NOREDO option.

11. Recover the data file with the NOREDO option.

Identify the required steps in the correct order.

Select an option, then click Submit answer.

  • ○

    4, 8, 11, 5
  • ○

    1, 3, 8, 11, 9
  • ○

    1, 2, 6, 3, 7, 10, 9
  • ○

    1, 3, 7, 10, 9
  • ○

    1, 2, 6, 3, 8, 11, 9