READ Free Dumps For Oracle- 1z0-060
Question ID 20766 | 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?
|
Option A | It collects data from SGA and compares it with a preserved snapshot.
|
Option B | It collects data from SGA, analyzes it, and provides a report.
|
Option C | It collects data from SGA and compares it with the latest snapshot.
|
Option D | It collects data from both SGA and PGA, analyzes it, and provides a report.
|
Correct Answer | B |
Explanation Note: * The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customercreated 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 Real 12 Oracle 1z0-060 Exam 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.
Question ID 20767 | The tnsnames.ora file has an entry for the service alias ORCL as follows:
The TNS ping command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database
instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
|
Option A | The listener is not running on the database node.
|
Option B | The TNS_ADMIN environment variable is set to the wrong value.
|
Option C | The orcl.oracle.com database service is not registered with the listener.
|
Option D | The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
|
Option E | The listener is running on a different port.
|
Correct Answer | C |
Explanation Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.