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

1z0-063 Exam Dumps - Oracle Database 12c: Advanced Administration

Go to page:

Question # 4

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

The root and seed databases are included in the duplication.

Only the SALES PDB is duplicated as the non-CDB CDBDUP.

A backup of the SALES PDB must exist before the execution of the command.

An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

RMAN must be connected to a recovery catalog for the execution of the command.

Full Access

Question # 5

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

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 recovery_catalog_owner role should be granted to the virtual catalog owner.

Full Access

Question # 6

Which two are benefits of unified auditing in full mode? (Choose two.)

The audit trail is in a single format.

All audit data is written to both the traditional locations and to the unified location.

The audit trail is read-only.

Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

The audit trail uses less space.

Full Access

Question # 7

Which two statements are true about service for pluggable databases (PDBs)? (Choose two.)

The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.

When a PDB is created, a service with the same name as the PDB is created in the PDB.

Only a common user can create additional services for a PDB.

Full Access

Question # 8

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.

What must you do to make the database operational in OUSERVER1?

Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.

Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.

Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.

Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

Full Access