Free 1z0-062 Oracle Updates

Oracle Database 12c: Installation and Administration Questions and Answers

Question 5

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.

Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

BACKUP DATABASE while connected to the PDB1 container

BACKUP DATABASE while connected to the boot container

BACKUP PLUGGABLE database PDB1 while connected to PDB2

Question 6

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.

The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.

What must you do first in this situation to attempt to fix this problem?

Run catuppst.sql to perform revalidation actions

Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.

Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Question 7

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

Create an event-based job.

Create a lightweight job.

Specify the job as a member of a job class.

Use a job array.

Question 8

You execute this command:

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

Space utilization inside segments is mapped by bitmaps.

Segments are automatically shrunk and compressed when rows are deleted.

The PCTFREE storage parameter has no effect on segments created in this tablespace.

The PCTUSED storage parameter has no effect on segments created in this tablespace.