QUESTION 197
These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction
Which of these will be stored in the Shared Pool if the necessary configurations are done?
A. 1 and 2
B. 2 and 5
C. 1,3, and 4
D. 3,4 and 5
E. 1,2,3 and 4
Correct Answer: C
These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction
Which of these will be stored in the Shared Pool if the necessary configurations are done?
A. 1 and 2
B. 2 and 5
C. 1,3, and 4
D. 3,4 and 5
E. 1,2,3 and 4
Correct Answer: C
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT1226
The shared pool caches various types of program data. For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that occurs in the database. For example, if a user executes a SQL statement, then Oracle Database accesses the shared pool.
The shared pool caches various types of program data. For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that occurs in the database. For example, if a user executes a SQL statement, then Oracle Database accesses the shared pool.
从下图可知：
Shared Pool包含：
-
Library Cache
存储SQL及其执行计划；PL/SQL代码； -
Data Dictionary Cache
存储模式对象的描述信息或元数据 -
Server Result Cache
存储SQL查询和PL/SQL函数结果
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2096298/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
私拉乱接导致网络打印机故障
下一篇：
1Z0-052 V12.49 Q13
请登录后发表评论
登录
全部评论
