Database Management Systems

This background process is responsible for signaling database writer at the checkpoints and updating all the datafiles and control files.

This memory component of the SGA contains share memory construct such as shared SQL area.

It consists of internal memory structures and process.

This logical storage structure does not actually contain data.

This memory component is used for operations such as bitmap merge, sorting etc.

This memory component of the SGA stores the most recently used block of data.

This background process cleans up temporary segments that are no longer in use and recovers terminated transactions skipped during recovery.

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

This memory component of the SGA is a circular buffer that stores redo entries - a log of changes made to the database.

This RAID level refers striped set with distributed parity and block-interleaved distributed parity.

This database described as control file contains recovery meta data i.e. information about backups.

This area is a directory that serves as the default storage area for files related to recovery.

This node participating in the session tree instructs the commit point site to initiate the global commit of the transaction, if all nodes prepare successfully.

This node participating in the session tree is responsible for coordinating the transaction among the nodes?

The activity of ensuring atomicity in the presence of transaction aborts is called transaction recovery.