nerdexam
Oracle

1Z0-052 · Question #244

You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the…

The correct answer is A. Oracle Management Agent. To centrally manage multiple remote databases using Enterprise Manager Grid Control, the Oracle Management Agent must be installed and running on each host where a target database resides.

Managing the Database Instance

Question

You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases, creating and managing tablespaces and database users, and taking regular backups, for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective?

Options

  • AOracle Management Agent
  • BEnterprise Manager with Grid Control
  • CEnterprise Manager with Database Control
  • DOperating System Socket for incoming requests
  • EReal Application Cluster (RAC) with three instances
  • FEnterprise Manager with Generic Database Management

How the community answered

(24 responses)
  • A
    88% (21)
  • C
    4% (1)
  • D
    4% (1)
  • E
    4% (1)

Why each option

To centrally manage multiple remote databases using Enterprise Manager Grid Control, the Oracle Management Agent must be installed and running on each host where a target database resides.

AOracle Management AgentCorrect

The Oracle Management Agent is a lightweight process that runs on each target host and acts as the communication bridge between the host and the central Enterprise Manager repository; it collects metrics, executes jobs such as startup/shutdown and backups, and relays management commands, making remote administration of all three databases from London possible.

BEnterprise Manager with Grid Control

Enterprise Manager Grid Control is the central console running in London from which you administer the databases; it is not the component that needs to run on each remote host.

CEnterprise Manager with Database Control

Enterprise Manager Database Control is a single-database management tool deployed per database and does not support centralized management of multiple databases from a remote location.

DOperating System Socket for incoming requests

An OS socket is a generic networking primitive, not a specific Oracle component, and it alone cannot enable the full administrative capabilities described.

EReal Application Cluster (RAC) with three instances

Real Application Clusters (RAC) provides high availability and scalability for a single database across multiple nodes and is unrelated to remote multi-database administration.

FEnterprise Manager with Generic Database Management

'Enterprise Manager with Generic Database Management' is not a real Oracle product or component.

Concept tested: Oracle Management Agent role in Enterprise Manager Grid Control

Source: https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emadm/installing-oracle-management-agent.html

Topics

#Oracle Management Agent#Enterprise Manager Grid Control#remote administration#multi-database management

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice