Which of the following background processes is used to resolve distributed transactions that are pending due to a network failure or system failure in a distributed database?

Which of the following logical storage structures are the logical structures that directly refer to the database's data?

Which of the following memory components of the SGA contains 'dirty' or modified blocks and clean or unused blocks?

Which of the following files can have certain characteristic set to let them automatically extend when the database runs out of space?

Which of the following memory components of the SGA is a circular buffer that contains redo entries, which reflect changes made to the database?

Which of the following background processes is designed to perform batched writes with high efficiency?

In which of the following logical storage structures dooes the disk access time improve because related rows are physically stored together?

The primary function of which of the following files is to record all changes made to data?

Which of the following memory components of the PGA is used for operations such as bitmap merge, bitmap create operations, etc?

Which of the following background processes cleans up temporary segments that are no longer in use?

Which of the following memory components of the SGA provides large memory allocations for Oracle backup and restore operations, I/O server processes, etc.?

Which of the following logical storage structures can also be considered a stored query?

The entries such as tablespace names, checkpoint information, as and when checkpoints are made, etc., are maintained in which of the following files?

Which of the following background processes checks on dispatcher and server process and restart them if they have failed?

In a shared server enviornment, which of the following memory components of the PGA is located in the system global area?