单选题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？（）ASGABPGACShared PoolDStreams Pool
单选题
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？（）
A
SGA
B
PGA
C
Shared Pool
D
Streams Pool
参考解析
解析：
暂无解析
相关考题：
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?() A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
Which of the following correctly describe steps in the OSI data encapsulation process?() A. Transport layer divides a data stream into segments adds reliability flow control informationB. Data link layer adds physical source destination address an FCS to the segmentC. Packets are created when the network layer encapsulate a frame with source destination host address protocol related control informationD. Packets are created when the network layers adds layers 3 address control information to a segmentE. The presentation layer translated bits into bits into voltages for transmission across the physical link
Which of the following correctly describe steps in the OSI data encapsulation process?（）A、The transport layer divides a data stream into segments and may add reliability and flow control information.B、The data link layer adds physical source and destination addresses and an FCS to the segment.C、Packets are created when the network layer encapsulates a frame with source and destination host addresses and protocol-related control information.D、Packets are created when the network layer adds Layer 3 addresses and control information to a segment.E、The presentation layer translates bits into voltages for transmission across the physical link.
Which of the following correctly describe steps in the OSI data encapsulation process?（）A、Transport layer divides a data stream into segments adds reliability flow control informationB、Data link layer adds physical source destination address an FCS to the segmentC、Packets are created when the network layer encapsulate a frame with source destination host address protocol related control informationD、Packets are created when the network layers adds layers 3 address control information to a segmentE、The presentation layer translated bits into bits into voltages for transmission across the physical link
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？（）A、SGAB、PGAC、Shared PoolD、Streams Pool
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？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
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（）A、To limit the User Global Area （UGA） memory allocated to a session from the SGAB、To limit the amount of memory to be used for the dispatcher queue of a session in SGAC、To limit the amount of memory to be used for the request pool in System Global Area （SGA）D、To control the amount of memory allocated in SGA for the local variables for each shared server process
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
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？（）A、The PMON process registers the request in the response queue.B、A shared sever places the process request in the response queue.C、A request within the request queue is processed by an idle shared server process.D、A dispatcher assigns a request from the request queue to and idle shared server process.
Which statement is true regarding Oracle Shared Server architecture？（）A、A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B、Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.C、Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. D、Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
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？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
Oracle Instance由哪两个部分组成？（）A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process
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？（）A、large poolB、streams poolC、keep buffer cacheD、recycle buffer cache
Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
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？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
With dynamic service registration， which process registers instance information with the listener？（）A、SMONB、PMONC、shared serverD、dedicated server
单选题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？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题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？（）Alarge poolBstreams poolCkeep buffer cacheDrecycle buffer cache
单选题Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）Ato limit the User Global Area （UGA） memory allocated to a session from the SGABto limit the amount of memory to be used for the dispatcher queue of a session in SGACto limit the amount of memory to be used for the request pool in System Global Area （SGA）Dto control the amount of memory allocated in SGA for the local variables for each shared server process
单选题With dynamic service registration， which process registers instance information with the listener？（）ASMONBPMONCshared serverDdedicated server
单选题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？（）ASGABPGACShared PoolDStreams Pool
单选题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？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题Which statement is true regarding Oracle Shared Server architecture？（）AA dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. BUnder the Oracle Shared Server architecture, client-user processes connect to shared user processes.CEach dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. DOracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
单选题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？（）AThe PMON process registers the request in the response queue.BA shared sever places the process request in the response queue.CA request within the request queue is processed by an idle shared server process.DA dispatcher assigns a request from the request queue to and idle shared server process.
多选题Which of the following correctly describe steps in the OSI data encapsulation process?（）ATransport layer divides a data stream into segments adds reliability flow control informationBData link layer adds physical source destination address an FCS to the segmentCPackets are created when the network layer encapsulate a frame with source destination host address protocol related control informationDPackets are created when the network layers adds layers 3 address control information to a segmentEThe presentation layer translated bits into bits into voltages for transmission across the physical link
单选题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？（）A recycle buffer cacheB large poolC streams poolD keep buffer cacheE redo log buffer
多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables