单选题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

题目

单选题

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

Library cache

Row cache

Dictionary cache

Large area

Buffer cache

参考答案和解析

正确答案： E

解析：暂无解析

更多“单选题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”相关问题

第1题

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

点击查看答案
第2题

Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache

点击查看答案
第3题

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

点击查看答案
第4题

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

点击查看答案
第5题

You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）A、because 4194304 is the granule sizeB、because 4194304 is the standard block sizeC、because 4194304 is the largest nonstandard block size defined in the databaseD、because 4194304 is the total size of data already available in the database buffer cache

点击查看答案
第6题

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.

点击查看答案
第7题

单选题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 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

题目

参考答案和解析

更多“单选题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”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容