← Back to exam page

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

Loading demo links...

Showing 1–3 of 20 questions

Question 1

You must track all transactions that modify certain tables in the sales schema for at least three years.

Automatic undo management is enabled for the database with a retention of one day.

Which two must you do to track the transactions? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Enable supplemental logging for the database.
  • ○

    Specify undo retention guarantee for the database.
  • ○

    Create a Flashback Data Archive in the tablespace where the tables are stored.
  • ○

    Create a Flashback Data Archive in any suitable tablespace.
  • ○

    Enable Flashback Data Archiving for the tables that require tracking.
Question 2

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The ability of users to audit their own schema objects is not available in the post-migrated database.
  • ○

    Operating system audit trail is available in the post-migrated database.
  • ○

    Network auditing is available in the post-migrated database.
  • ○

    Mandatory auditing of audit administrative actions is available in the post-migrated database.
Question 3

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.

Which two methods or commands would you use to accomplish this task? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    RMAN CONVERT command
  • ○

    Data Pump Export and import
  • ○

    Conventional Export and Import
  • ○

    The BACKUP AS COPY DATABASE . . . command of RMAN
  • ○

    DBMS_FILE_TRANSFER with transportable tablespace