Which of the following background processes is an optional background process present only when a shared server configuration is used?

At the finest level of granularity, Oracle database data is stored in which of the following logical storage structures?

The entries, such as current online redo log file sequence number, timestamp of database creation, etc., are maintained in which of the following files?

The information in which of the following files is used only to recover the database from a system failure that prevents database data from being written to the data files?

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

Which of the following memory components of the PGA is used for operations, such as bitmap creation, sorting operations etc.?

Which of the following background processes writes the redo log entries sequentially into an online redo log?

A tablespace can have many _______________ files associated with it.

Which of the following memory components of the SGA is used to hold data blocks read from data files by server processes?

Which of the following always opens one database?

Which of the following logical storage structures commonly group together all application objects using some administrative operations?

Which of the following background processes is responsible for cleaning up the cache and freeing resources that the process was using?

In a dedicated server environment, which of the following memory area is created in the program global area of their server process?

In which of the following memory components of the SGA are the sizes of the two caches, such as library cache and the data dicitionary caches not set individually and are automatically determined by the Oracle server?

Which of the following memory components of the SGA is a circular buffer that contains redo entries?