（）用于存放SQL语句最近使用的数据块。A、Shared PoolB、Buffer CacheC、PGAD、UGA
（）用于存放SQL语句最近使用的数据块。
- A、Shared Pool
- B、Buffer Cache
- C、PGA
- D、UGA
相关考题：
SQL语句的编译和执行是在SGA的哪一部分中进行的() A.Database Buffer CacheB.Redo Log BuffC.Shared PoolD.Large PoolE.Java Pool
在SQL语句执行前的解析阶段,要判断其中涉及的表名和列名是否合法,判断所依据的信息存放在() A.PGAB.SHARED POOLC.DATABASE BUFFER CACHED.REDO LOG BUFFER CACHEE.LARGE POOL
在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）A、PGAB、SHARED POOLC、DATABASE BUFFER CACHED、REDO LOG BUFFER CACHEE、LARGE POOL
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache
Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations A、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
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
SQL语句的编译和执行是在SGA的哪一部分中进行的（）A、Database Buffer CacheB、Redo Log BufferC、Shared PoolD、Large PoolE、Java Pool
单选题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
单选题You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A streams poolB shared poolC log bufferD keep buffer cacheE recycle buffer cache
单选题在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）APGABSHARED POOLCDATABASE BUFFER CACHEDREDO LOG BUFFER CACHEELARGE POOL