1Z0-082 Oracle Database Monitoring and Auditing

Question 1

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

Accepted Answer

ADDM (Automatic Database Diagnostic Monitor)

Answer

SQL Tuning Advisor

Answer

ASMM (Automatic Shared Memory Management)

Answer

Data Pump

Question 2

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

Accepted Answer

Automatic Workload Repository

Answer

Automatic Write Repository

Answer

Active Work Record

Answer

Alert Warning Register

Question 3

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

Accepted Answer

V$SESSION

Answer

V$PROCESS

Answer

V$TRANSACTION

Answer

V$SQL

Question 4

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

Accepted Answer

The Alert Log

Answer

The redo log files

Answer

The control file

Answer

V$DIAG_INFO

Question 5

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

Accepted Answer

SQL Monitor (Real-Time SQL Monitoring)

Answer

AWR Report

Answer

ADDM Finding

Answer

SQL Tuning Advisor

Question 6

What does ADDM stand for in Oracle Database?

Accepted Answer

Automatic Database Diagnostic Monitor

Answer

Automatic Data Distribution Manager

Answer

Active Database Diagnostic Module

Answer

Adaptive DDL Management Module