Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Oracle Database Monitoring and Auditing Flashcards

6 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Oracle Database Monitoring and Auditing flashcards as text

  1. Which Oracle feature automatically diagnoses performance problems and recommends solutions using data from AWR?

    Answer: ADDM (Automatic Database Diagnostic Monitor)

    ADDM automatically analyzes AWR snapshots after each interval and identifies the top performance bottlenecks along with actionable recommendations.

  2. What does AWR stand for in the context of Oracle Database performance management?

    Answer: Automatic Workload Repository

    The Automatic Workload Repository (AWR) automatically collects, processes, and maintains performance statistics for database self-management and tuning.

  3. Which dynamic performance view shows all currently connected sessions in an Oracle database?

    Answer: V$SESSION

    V$SESSION contains one row for each current session connected to the Oracle database, including background and user sessions with their status and resource usage.

  4. Where does Oracle Database write critical error messages, startup and shutdown information, and background process messages?

    Answer: The Alert Log

    The Alert Log is a chronological file that records database events including startup/shutdown, errors (ORA- messages), and administrative commands.

  5. Which Oracle Enterprise Manager feature provides real-time SQL execution monitoring showing active SQL plan steps?

    Answer: SQL Monitor (Real-Time SQL Monitoring)

    Real-Time SQL Monitoring tracks long-running SQL statements in real time, displaying active plan operations, elapsed time, I/O, and CPU usage per step.

  6. What does ADDM stand for in Oracle Database?

    Answer: Automatic Database Diagnostic Monitor

    ADDM stands for Automatic Database Diagnostic Monitor, the self-diagnosing engine that analyzes AWR data to identify and report database performance issues.