Which Oracle memory structure caches recently accessed data blocks?
Correct!
Wrong!
The Database Buffer Cache holds copies of data blocks read from data files.
The process responsible for writing redo entries from the redo log buffer to the online redo log files is:
Correct!
Wrong!
LGWR writes redo records to disk to ensure recoverability.
Which file records the physical structure of the database, including data file locations and log history?
Correct!
Wrong!
The control file maintains the database’s structure metadata and checkpoint information.
Oracle SQL*Loader is primarily used to:
Correct!
Wrong!
SQL*Loader loads data from external files into Oracle tables efficiently.
Data Pump Export (expdp) differs from the legacy EXPORT utility by:
Correct!
Wrong!
Data Pump uses direct path and parallel execution for faster data movement.
Enterprise Manager (EM) Express provides:
Correct!
Wrong!
EM Express is a lightweight web-based tool for monitoring and administering Oracle databases.
Loading Questions...
Automatic Storage Management (ASM) simplifies storage by:
Correct!
Wrong!
ASM manages disk groups and evenly spreads data, improving performance and manageability.
Which component parses and caches SQL execution plans in memory?
Correct!
Wrong!
The library cache (part of Shared Pool) stores parsed SQL and PL/SQL code for reuse.
Oracle Net Listener’s primary role is to:
Correct!
Wrong!
The listener accepts client connection requests and establishes sessions with the database.