052-14

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

1. 描述信息或元数据关于用户对象被查询通过 SQL 语句--shared pool
2. 数据操纵语言(DML)和数据定义语言(DDL)的运行时间区域
3. SQL 查询和 PL/SQL 函数结果--shared pool
4. SQL 游标,PL/SQL 程序和 Java 类的可执行形式--shared pool
5. 通过一个事务重建数据库所做的更改的必要信息

 


posted @ 2017-12-01 13:13  巴啦啦大魔王  阅读(140)  评论(0编辑  收藏  举报