Which of the following processes is responsible for signaling database writer at the checkpoints and updating all the datafiles and control files of the database to indicate the most recent checkpoints?

Which of the following memory components of the system global area provides large memory allocations for oracle backup and restore operations, I/O server process, session memory, etc?

Which of the following triggers provides a transparent way of modifying view that cannot be modified directly through DML statements?

Which of the following is a procedure that run implicitly when an INSERT, UPDATE or DELETE statement is issued against the associated table?

In which of the following components of the recovery manager environment is the client application spawn server sessions on the target database to do work of backup or recovery?

Which of the following types of triggers fires after a successful entry of a user within the system?

Which of the following types of trigger is fired each time, when the table is affected by the triggering statement?

Which of the following parts of the trigger specifies a boolean expression that must be true for the trigger to fire?

Which of the following triggers runs its trigger action, even if a triggering statement is issued and the trigger restriction would evaluate to TRUE?

Which of the following file's informations is used only to recover the database from a media failure?

Which of the following processes cleans up temporary segments that are no longer in use and recovers terminated transactions skipped during recovery because of file-read?

Which of the following parts of trigger is the procedure that contains the SQL statements and code to be run when a trigger statement is issued?

Which of the following types of trigger fires when the database is opened by an instance?

In which of the following redundant arrays of independent disks level, the single parity disk is a bottle-neck for writing, since every write requires updating the parity data?

Which of the following nodes instructs all nodes to initiate a global abort of the transaction if there is an abort response?