单选题在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）APGABSHARED POOLCDATABASE BUFFER CACHEDREDO LOG BUFFER CACHEELARGE POOL
单选题
在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）
A
PGA
B
SHARED POOL
C
DATABASE BUFFER CACHE
D
REDO LOG BUFFER CACHE
E
LARGE POOL
参考解析
解析：
暂无解析
相关考题：
A senior DBA asked you to execute the following command to improve performance:SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）A. The keep pool is not configured.B. Automatic Workarea Management is not configured.C. Automatic Shared Memory Management is not enabled.D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
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
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？ A、 database buffer cacheB、 shared poolC、 PGAD、 large 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
在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）
A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
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.
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database 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
Which component of the SGA stores parsed SQL statements is used for process sharing?（）A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
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.
单选题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
单选题A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）AThe keep pool is not configured.BAutomatic Workarea Management is not configured.CAutomatic Shared Memory Management is not enabled.DThe data blocks in the SUBSCRIBE_LOG table are rarely accessed.EAll the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
单选题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
单选题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.
单选题In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？A database buffer cacheB shared poolC PGAD large pool
单选题在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）APGABSHARED POOLCDATABASE BUFFER CACHEDREDO LOG BUFFER CACHEELARGE 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
单选题SQL语句的编译和执行是在SGA的哪一部分中进行的（）ADatabase Buffer CacheBRedo Log BufferCShared PoolDLarge PoolEJava Pool
单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）AConfigure the KEEP buffer pool and alter the table with the corresponding storage clause.BIncrease the database buffer cache size.CConfigure the RECYCLE buffer pool and alter the table with the corresponding storage clause.DConfigure Automata Shared Memory Management.EConfigure Automatic Memory Management