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? 

Answer options:

A. It collects data from SGA and compares it with a preserved snapshot.
B. It collects data from SGA, analyzes it, and provides a report.
C. It collects data from SGA and compares it with the latest snapshot.
D. It collects data from both SGA and PGA, analyzes it, and provides a report.

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.