← Back to exam page

1z0-067 – Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP

Loading demo links...

Showing 7–9 of 15 questions

Question 7

Which two statements are true about making RMAN image copies of a database? Choose two.

Select all that apply, then click Submit answer.

  • ○

    They can be made only when the database is running in ARCHIVELOG mode.
  • ○

    They consist of all used and unused blocks in the data files.
  • ○

    They can be made only when the database is in MOUNT state.
  • ○

    They can only be written to disk.
  • ○

    They can be made only when the database is running in NOARCHIVELOG mode.
Question 8

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?

Select an option, then click Submit answer.

  • ○

    Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
  • ○

    Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
  • ○

    Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
  • ○

    Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Question 9

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS. Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

Select an option, then click Submit answer.

  • ○

    Supplemental logging is not enabled for the database.
  • ○

    The undo data that existed for versions of rows before the change to the table structure is invalidated.
  • ○

    The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
  • ○

    Undo retention guarantee is not enabled.
  • ○

    Flashback Data Archive is full after the first update statement.