SGA
PGA
Shared Pool
Streams Pool
第1题:
Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()
第2题:
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
第3题:
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
第4题:
Which statement is true regarding Oracle Shared Server architecture?()
第5题:
Oracle Instance由哪两个部分组成?()
第6题:
Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)
第7题:
With dynamic service registration, which process registers instance information with the listener?()
第8题:
large pool
streams pool
keep buffer cache
recycle buffer cache
第9题:
SMON
PMON
shared server
dedicated server
第10题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第11题:
The PMON process registers the request in the response queue.
A shared sever places the process request in the response queue.
A request within the request queue is processed by an idle shared server process.
A dispatcher assigns a request from the request queue to and idle shared server process.
第12题:
recycle buffer cache
large pool
streams pool
keep buffer cache
redo log buffer
第13题:
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead?()
第14题:
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
第15题:
Click the Exhibit button and examine the diagram, which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4?()
第16题:
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第17题:
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()
第18题:
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager (RMAN). The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第19题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第20题:
to limit the User Global Area (UGA) memory allocated to a session from the SGA
to limit the amount of memory to be used for the dispatcher queue of a session in SGA
to limit the amount of memory to be used for the request pool in System Global Area (SGA)
to control the amount of memory allocated in SGA for the local variables for each shared server process
第21题:
SGA
PGA
Shared Pool
Streams Pool
第22题:
A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
第23题:
Transport layer divides a data stream into segments & adds reliability & flow control information
Data link layer adds physical source & destination address & an FCS to the segment
Packets are created when the network layer encapsulate a frame with source & destination host address& protocol related control information
Packets are created when the network layers adds layers 3 address & control information to a segment
The presentation layer translated bits into bits into voltages for transmission across the physical link
第24题:
Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables