Free Oracle 1z0-067 Exam Dumps Questions & Answers

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

• A.  The recovery_catalog_owner role should be granted to the virtual catalog owner.
• B.  A base recovery catalog should exist.
• C.  The owner of VPC cannot own recovery catalog.
• D.  At least one target database should be registered in the recovery catalog.
• E.  The register database privilege should be granted to the virtual catalog owner.

Identify two scenarios in which the RMAN crosscheck command can be used.

• A.  when checking for backups that are not required as per the retention policy
• B.  when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
• C.  when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
• D.  when listing backups that are required for recovery operations
• E.  when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

• A.  The PDB is closed and requires media recovery at the PDB level.
• B.  The PDB does not close and starts by using the default temporary tablespace defined for the CDB.
• C.  The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• D.  The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

• A.  To clone an existing PDB.
• B.  Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
• C.  Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.
• D.  Use PDB$SEED for creating a PDB.
• E.  Use Enterprise Manager Database Express to create a PDB in an existing CDB.

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

• A.  The DMU can report columns that are not represented in the converted characterset
• B.  The DMU can report columns that are too long in the converted characterset
• C.  The release of the database to be converted can be any release since 9.2.0.8.
• D.  The database to be migrated must be opened read-only.
• E.  A DBA can check specific tables with the DMU