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 # 9

Examine this command:

SQL>ALTER SYSTEM SET db_securefile = â€˜IGNOREâ€™;

Which statement is true?

It forces SecureFiles to be created even if the BASICFILE option is specified

It forces SecureFiles to be created using default values and ignores any SECUREFILE parameters

It forces BasicFiles to be created even if the SECUREFILE option is specified

It ignores the SECUREFILE option only if storing the LOB segment in a Free List managed tablespace

Full Access

Question # 10

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

A base recovery catalog should exist.

The owner of VPC cannot own recovery catalog.

At least one target database should be registered in the recovery catalog.

The register database privilege should be granted to the virtual catalog owner.

The DBA role should be granted to the virtual catalog owner.

Full Access

Question # 11

Which two statements are true about RMAN duplexed backups? (Choose two.)

For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

It is only supported for backups to tape via media management interface.

It is not supported for image copies.

Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

Duplex backups can contain only data files and control files.

Full Access

Question # 12

Which two statements describe the relationship between a window, a resource plan, and a job class?

A window specifies a resource plan that will be activated when that window becomes active.

A window specifies a job class that will be activated when that window becomes active.

A job class specifies a window that will be open when that job class becomes active.

A window in association with a resource plan controls a job class allocation.

A window in association with a job class controls a resource allocation.

Full Access

Question # 13

Which three statements are true about Oracle Restart?

It can be configured to automatically attempt to restart various components after a hardware or software failure.

While starting any components, it automatically attempts to start all dependencies first and in proper order.

It can be configured to automatically restart a database in case of normal shutdown of the database instance.

It can be used to only start Oracle components.

It runs periodic check operations to monitor the health of Oracle components.

Full Access

Question # 14

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

An unplugged PDB can be plugged into the same or another container database (CDB).

PDB data files are automatically removed from disk.

A PDB must have been opened at least once after creation.

A PDB must be in closed state before it can be unplugged.

A PDB must be in MOUNT state before it can be unplugged.

Full Access

Question # 15

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

The following are the possible steps to accomplish this task:

1. Place all the user-defined tablespace in read-only mode on the source database.

2. Upgrade the source database to a 12c version.

3. Create a new PDB in the target container database.

4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

5. Copy the associated data files and export the dump file to the desired location in the target database.

6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify the correct order of the required steps.

2, 1, 3, 4, 5, 6

1, 3, 4, 5, 6, 7

1, 4, 3, 5, 6, 7

2, 1, 3, 4, 5, 6, 7

1, 5, 6, 4, 3, 2

Full Access

Question # 16

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Full Access

Go to page: