Oracle Exam 1Z0-060 Topic 10 Question 5 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 5
Topic #: 10

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.

How does real-time Automatic Database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

AIt collects data from SGA and compares it with a preserved snapshot.

BIt collects data from SGA, analyzes it, and provides a report.

CIt collects data from SGA and compares it with the latest snapshot.

DIt collects data from both SGA and PGA, analyzes it, and provides a report.

Show Suggested Answer

Suggested Answer: B

Note:

* The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

* The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle ''instance'' (an instance is your database programs and RAM).

* The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information for a single process.

by Layla at May 09, 2022, 09:10 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!