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

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00','YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00','YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

• A. 2, 3, 5, 6
• B. 1, 2, 5
• C. 1, 3, 6
• D. 3, 4, 5

You want to export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.

• A. 2, 1, 3, 7, 6, and 8
• B. 2, 1, 3, 5, 7, 6, and 8
• C. 2, 1, 3, 7, 6, 9, and 8
• D. 2, 1, 4, 5, 3, 7, 6, 9, and 8

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1.Place all user-defined tablespaces in read-only mode on the source database.
2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3.Perform a full transportable export on the source database with the parameters VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

• A. 1, 2,4, and 7
• B. 1, 3, 5, 4, 2, and 7
• C. 1, 2, 4, 6, 5, 3, and 7
• D. 2, 4, 5, 6, and 7

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR).
Examine the initialization parameters set in your database.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring What is the location of the ADR base?

• A. It is set to /u01/app/oracle/admin/en12.1.0/adump.
• B. It is set to /u01/app/oracle.
• C. It is set to /u01/app/oracle/flash_recovery_area.
• D. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.

Which three statements are true about Consolidated Database Replay?

• A. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
• B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
• C. A subset of the captured workload can be replayed.
• D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
• E. The workload capture and replay systems must have the same operating system (OS).