Database Management Systems

This memory component of the system global area is used by the oracle streams product for its functioning.

It writes modified blocks from the database buffer cache to the datafiles.

This memory component of the program global area is used for operations such as sorting,hash-joins operations etc..

It is a set of extents allocated for a certain logical structure such as table.

A database is divided into logical storage units called tablespace, which groups related logical structures together.

This memory component of the program global area is in turn made up the persistent area.

It is the smallest unit of allocation in an oracle database.

The data of logical database structures such as tables and indexes are physically stored in the data files allocated for a database.

The contents of the redo log buffer are essential for instance recovery purposes.

It copies the online redo log files to archival storage after a log switch has ooccurred.

The contents of the database buffer cache are written to data files on disk by the database writer background process.

The information in a redo log file is used only to recover the database from a system or media failure.

This server system in database system architecture allows clients to interact with the servers by making requests to read or update data in units, such as files or pages.

This issue in parallel systems refers to the rate at which transactions are submitted and increases the size of the database proportional to the transaction rate.

This object in data warehouse is similar to the data dictionary or the data catalog in a DBMS.