OEM Console Windows - Quiz Explanation

The correct answers are indicated below, along with the text that explains the correct answers.
 
1. Which OEM console window is used to cancel a server process?
Please select the best answer.
  A. The Navigator window
  B. The Job Scheduling window
  C. The Map window
  D. Event Manager window
  The correct answer is A.
In Oracle Enterprise Manager (OEM):
  • The Navigator window provides a hierarchical view of all managed targets such as databases, listeners, and nodes.
    • Access database instances
    • Monitor sessions and server processes
    • Terminate or cancel a specific server process

This makes it the correct choice for tasks like cancelling a server process.
The other options serve different purposes:
  • B. Job Scheduling window: Used for managing and scheduling jobs.
  • C. Map window: Displays topological views of your networked Oracle environment.
  • D. Event Manager window: Monitors and alerts on system events and thresholds, not direct process management.

2. Which OEM console window is used to display all of the tables for an Oracle user?
Please select the best answer.
  A. The Navigator window
  B. The Job Scheduling window
  C. Map window
  D. Event Manager window
  The correct answer is A.
In Oracle Enterprise Manager (OEM):
  • The Navigator window is your primary interface for exploring and managing database objects.
    • It displays a hierarchical tree structure for database components including:
      • Users (Schemas)
      • Tables
      • Views
      • Indexes
      • Procedures, etc.
  • By expanding a specific user/schema node, you can view all tables owned by that user.

Here is an explanation tailored for Oracle 19c, clarifying why options B, C, and D are incorrect in the context of displaying all tables for an Oracle user:

  • ❌ B. The Job Scheduling window

    The Job Scheduling window is used to create, view, and manage scheduled jobs—such as backups, reports, or maintenance tasks. It does not display database schema objects like tables, views, or indexes. Its focus is on operational automation, not schema exploration.

  • ❌ C. Map window

    The Map window was a feature in earlier versions of OEM (pre-10g) that offered a topological view of the Oracle environment, including icons for databases, listeners, and nodes. This visual representation helped DBAs understand system relationships and availability, but it was never used for viewing schema objects. Moreover, it is deprecated and not part of OEM Cloud Control in 19c.

  • ❌ D. Event Manager window

    The Event Manager window is designed for monitoring system events, alerts, and thresholds. It tracks predefined conditions (e.g., high CPU usage, tablespace thresholds) and integrates with Oracle's Intelligent Agent to notify DBAs. It does not provide a listing of tables or schema browsing features.
✅ Correct Answer: A. The Navigator window
In Oracle 19c OEM, the Navigator window is the correct and primary interface used to:
  • Explore schemas
  • View all tables, views, indexes, procedures, and users
  • Access detailed properties of database objects

3. The Oracle Enterprise Manager (OEM) Navigator is most similar in functionality to which other Oracle GUI-based administration tool for exploring database objects and schemas?
Please select the best answer.
  A. Oracle Net Manager
  B. B. Oracle SQL Developer
  C. C. Oracle Data Pump Manager
  D. D. Oracle Wallet Managerr
  The correct answer is B. Oracle SQL Developer
Oracle SQL Developer is a modern graphical interface that allows database developers and DBAs to explore database schemas, browse tables, run SQL queries, and manage users, similar to what the OEM Navigator does in Oracle Enterprise Manager. It has effectively replaced older tools like Schema Manager or Data Manager, which were used in earlier Oracle releases.
📘 Explanation (Oracle 19c Context):
The Oracle Enterprise Manager (OEM) Navigator is most similar in functionality to Oracle SQL Developer, a modern GUI-based tool widely used by developers and DBAs to explore and manage database objects such as tables, views, indexes, sequences, and PL/SQL code.
Just like the Navigator window in OEM, Oracle SQL Developer provides:
  • A schema browser to view user and system objects
  • The ability to run queries, create/edit objects, and generate DDL
  • Insight into data dictionary views, users, roles, and privileges

❌ Why the Other Options Are Incorrect:
  • A. Oracle Net Manager Used to configure Oracle Net Services (e.g., tnsnames.ora, listener.ora, and sqlnet.ora). It helps manage connection configurations, not schema objects.
  • C. Oracle Data Pump Manager Related to data export/import tasks using Oracle Data Pump (expdp/impdp). While it deals with moving schema data, it doesn’t provide schema browsing or object-level management.
  • D. Oracle Wallet Manager Used to manage Oracle Wallets, which store credentials and certificates for secure communication. It’s a security-focused utility, not for schema exploration or database object interaction.

📌 Summary: If you need a GUI to browse, modify, and query database schemas, both OEM Navigator and Oracle SQL Developer fulfill that role—making option B the correct and most up-to-date choice for Oracle 19c and beyond.

4. Which window of the OEM console would be used to display the size of a remote database SGA?
Please select the best answer.
  A. The Navigator window
  B. The Job Scheduler window
  C. The Map window
  D. The Event Manager window
  The correct answer is A.
Updated Explanation (Oracle 19c Context)
In older versions of Oracle Enterprise Manager (circa 2000), the Map window was used to visualize database environments graphically. Double-clicking a database icon in the Map window would reveal important runtime metrics, including SGA size for remote databases. However, in Oracle 19c, the Map window has been deprecated, and such functionality is now performed through the Navigator window or directly via Performance Hub in OEM Cloud Control.
  • Navigator window now allows detailed drill-down into memory components (like SGA) via links to instance performance and configuration views.
  • The Performance Hub can provide real-time and historical memory usage, making it the modern method for viewing SGA sizes.

❌ Breakdown of Incorrect Choices (Still Valid Reasoning):
  • B. Job Scheduler window – Displays and manages scheduled tasks, not memory metrics.
  • D. Event Manager window – Monitors alerts and thresholds, not memory usage or SGA stats.

🕰️ Summary for Historical Context:
  • ✅ In OEM 2.x (2000): Map window ➜ SGA size
  • ✅ In OEM 13c+ (Oracle 19c): Navigator window + Performance Hub ➜ SGA size