Practice Questions

Which tool automatically analyzes performance problems and provides recommendations in Oracle 19c?

A. SQL*Loader B. Automatic Database Diagnostic Monitor (ADDM) C. Data Pump D. Oracle Net Manager

Which view can be used to analyze historical performance data collected by AWR?

A. V$SESSION B. DBA_HIST_SNAPSHOT C. USER_TABLES D. V$LOG

Which component is responsible for generating execution plans in Oracle Database?

A. Resource Manager B. Optimizer C. Listener D. Recovery Manager

Which initialization parameter controls automatic memory management?

A. MEMORY_TARGET B. DB_BLOCK_SIZE C. PROCESSES D. OPEN_CURSORS

What is the main purpose of SQL Plan Management?

A. Backup SQL statements B. Enforce SQL execution plan stability C. Encrypt SQL queries D. Archive SQL logs

Which report helps identify top SQL statements consuming database time?

A. AWR Report B. Alert Log C. Listener Log D. Control File