System Global Area
Description: SGA in oracle Java/Oracle /C/C++Oracle | |
Number of Questions: 15 | |
Created by: Mohini Tyagi | |
Tags: SGA in oracle Java/Oracle /C/C++ Oracle |
Which of the following background processes is responsible for routing requests from connected user processes to available shared server processes?
At specific times, all modified database buffers in the SGA are written to the datafiles by which of the following background processes?
The information in which of the following files is used to recover the database from a media failure?
Which of the following memory components of the SGA contains modified blocks and clean or unchanged blocks?
A database that is divided into logical storage units is called :
With real application, which of the following background processes instance can perform instance recovery for instances?
The data of logical database structures such as tables and indexes are physically stored in which of the following files?
Which of the following logical storage structures is a specific number of contiguous data blocks obtained in a single allocation?
The redo log entries stored in which of the following memory components of the SGA are written to an online redo log?
Which of the following background processes is responsible for signaling database writer at the check points and updating all the datafiles and control files of the database?
Which of the following memory components of the SGA provides large memory allocations for Oracle backup and restore operations?
The entries such as the database identifier and name, redo log archive information, etc. are maintained in which of the following files?
A database uses and allocates free database space in which of the following logical storage structures?
When the segment finishes execution, the extents are returned to the system in which of the following logical storage structures?
Which of the following background processes copies the online redk log files to archival storage?