Note! Following 1z0-067 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:

Question # 33

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.

Which two backup solutions can be used?

RMAN recovery catalog

RMAN Media Management Library

Enterprise Manager Cloud Control

Enterprise Manager Database Express

Oracle Secure Backup

Full Access

Question # 34

Which parameter must be set to which value to implement automatic PGA memory management?

Set memory_target to zero.

Set STATISTICS_LEVEL to BASIC.

Set pga_aggregate_target to a nonzero value.

Set pga_aggregate_target and sga_target to the same value.

Set sgajtarget to zero.

Full Access

Question # 35

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

What is the easiest way to perform capacity planning for consolidation?

capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Full Access

Question # 36

Examine the command to create a pluggable database (PDB):

SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1

FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/â€™) PATH_PREFIX = '/disk2/oracle/pdb2';

Which two statements are true?

The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

The tablespace specifications of pdb2 are the same as pdb1.

All database objects belonging to common users in PD3I are cloned in PD32.

pdb2 is created with its own private undo and temp tablespaces.

Full Access

Question # 37

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN

{

ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;

EXECUTE SCRIPT arc_backup;

}

Which statement is true about the RMAN RUN block execution?

The script is executed and both DC1 and CH1 channels are used for script execution.

The execution of the script fails because multiple channels cannot exist simultaneously.

The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

The new channel, CH1, is ignored because a channel has been configured already.

Full Access

Question # 38

Which two statements are true regarding SecureFile lobs?

The amount of undo retained is user controlled.

They can be used only for nonpartitioned tables.

Fragmentation is minimized by using variable-sized chunks.

They support random reads and writes of encrypted LOB data.

Full Access

Question # 39

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.

Examine the steps to recover the database:

1. Restore the control files by using the RMAN restore controlfile command.

2. Mount the database.

3. Restore the data files by using the RMAN restore database command.

4. Open the database with the resetlogs option.

5. Recover the data files by using the RMAN recover using backup controlfile command.

6. Start the database instance in nomount state.

7. Connect to the target database by using a recovery catalog.

8. Open the database.

9. Restore the data file.

10. Recover the data file.

Identify the required steps in the correct order.