8.Observe the information in the columns:
来源:互联网 发布:程序流程图制作软件 编辑:程序博客网 时间:2024/05/21 21:38
8.Observe the information in the columns:
1: The SGA a. Text and parsed forms of all SQL statements
2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3: User-session data c. Security and resource usage information
4: The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents?
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
答案:C
解析:
1.SGA,System Global Area,至少包括三个部分:数据库高速缓冲区,共享池,sga 固定区,
其中共享池包括库高速缓存和数据字典高速缓存,库高速缓存又包括共享 sql 区和共享 pl/sql 区
2.the cursor state:cursor状态区,表示会话当前所使用的sql语句的处理状态
3.User-session data,用户会话数据,应该归属于会话信息区,主要包括会话的用户权限和优化统计信息
4.The stack space:堆栈区,包括其他的会话变量
1: The SGA a. Text and parsed forms of all SQL statements
2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3: User-session data c. Security and resource usage information
4: The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents?
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
答案:C
解析:
1.SGA,System Global Area,至少包括三个部分:数据库高速缓冲区,共享池,sga 固定区,
其中共享池包括库高速缓存和数据字典高速缓存,库高速缓存又包括共享 sql 区和共享 pl/sql 区
2.the cursor state:cursor状态区,表示会话当前所使用的sql语句的处理状态
3.User-session data,用户会话数据,应该归属于会话信息区,主要包括会话的用户权限和优化统计信息
4.The stack space:堆栈区,包括其他的会话变量
0 0
- 8.Observe the information in the columns:
- Accessing columns in the User Information List
- observe the real world
- Autosize the columns and rows in MSFlexGrid
- Hide the columns in table-control
- Should new index columns be in the key, or included?
- b is not in the spans of the columns of the martix A
- 64.View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
- 106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:
- 92.View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTI
- pip 警告!The default format will switch to columns in the future
- Windows10系统 DEPRECATION: The default format will switch to columns in the future解决!
- Unlocking Information in the Microsoft Office System Using XML
- How add debug information in the VC++ Win32 Release mode
- How add debug information in the VC++ Win32 Release mode
- Securing the Information Infrastructure
- Display the battery information
- poj2983Is the Information Reliable?
- 学习Android的点点滴滴--button click事件处理
- Refactor: replace type code with class (c++)
- mysql性能查看命令1
- 设置字体属性
- Intellij Idea 注释行如何自动缩进?
- 8.Observe the information in the columns:
- tomcat设置环境变量
- 自学知识总结
- RabbitMQ学习(十)之spring整合发送同步消息(注解实现)
- Hadoop单节点
- stm8s_atomthread
- 就让CSDN来见证我的成长吧!
- Notification及BroadcastReceiver
- VectorDrawable:适应不同分辨率的drawable资源