databases Online Quiz - 29
|Description: databases Online Quiz - 29|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Oracle Instance comprises of
SGA size is defined by parameter
PGA memory is allocated for each server process.
We can access data of database before session has been established.
Application reterieves data from database buffer cache is referred as
Various buffers are internally managed by database buffer cache
How we can configure PGA area in Oracle?
Redo log buffer data is used for recovery.
Which process writes redo log buffer to redo log files?
Shared Pool comprises of following components.
Transactions throughput is slower when data found from buffer cache.
Following is the optional area of SGA.
Instance recovery is perfomed by which process?
Cursor bind information is stored in which area of PGA.
Background process responsible to write contents of database buffer to data files.
When SQL query is parsed then it will look first definitions of table exist in following area.
BB Manager can be accessed through
Can activation password for the user once set be deleted?
Which Blackberry service connects to mail serverto provide e-mail, calendar, address lookup, attachment and wireless encryption key generation?
Can IT policy be deleted and dispatched viz BB Manager?