Oracle Database Administration II 1z0-083 Exam Questions with Experts Answers Updated Recently

A.  

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B.  

In a PDB plan, subplans may be used with up to eight consumer groups.

C.  

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D.  

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E.  

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

A.  

They are never considered obsolete by RMAN.

B.  

They can optionally be written to a fast recovery area (FRA).

C.  

All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D.  

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E.  

The SPFILE is included in the archival backup.

F.  

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

A.  

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

B.  

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

C.  

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

D.  

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.  

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

A.  

It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B.  

It must be invoked by a user with root user privileges.

C.  

Patches are applied via opatchauto.

D.  

Users must always input patch plans to opatchauto.

E.  

It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F.  

It applies patches in nonrolling mode by default.

G.  

It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.