← Back to exam page

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

Loading demo links...

Showing 13–15 of 15 questions

Question 13

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

How would you achieve this?

Select an option, then click Submit answer.

  • ○

    by using the RMAN SWITCH command to set the new location for the data files
  • ○

    by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host
  • ○

    by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host
  • ○

    by creating a new database in the new host, and then using the RMAN RECOVER command
Question 14

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1. Create a policy to capture the privileges used by a user for privilege analysis.

2. Generate a report with the data captured for a specified privilege capture.

3. Start analyzing the data captured by the policy.

4. Revoke the unused privileges.

5. Compare the used and unused privileges' lists.

6. Stop analyzing the data.

Identify the correct sequence of steps.

Select an option, then click Submit answer.

  • ○

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

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

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

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

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

Examine the steps required to perform the migration:

1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.

2. Place all tablespaces in read-only mode on the source database.

3. Upgrade the source database to Oracle Database 12c.

4. Copy the dump file and data files to the desired location in the target database.

5. Create a new PDB in the target CDB.

6. Synchronize the PDB on the target CDB.

7. Use Data Pump import on the new PDB by using the full transportable import options.

Identify the required steps in the correct order.

Select an option, then click Submit answer.

  • ○

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

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

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

    2, 1, 3, 5, 7, and 6