134.View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 l
来源:互联网 发布:ssm框架打印sql语句 编辑:程序博客网 时间:2024/05/17 09:24
134.View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener? (Choose two.)
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
答案:BD
解析:
A:错误,UNKNOW 为静态 READY 为动态这里显示的是UNKNOW说明是静态
B:正确
C:错误,这个的意思是当前的连接是两个
D:正确,这个的意思是到目前为止共有2个连接
我们测试一下
Service "wahaha3" has 1 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
--这里显示的是0个
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
---连续连接3次,并且断开
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
--查看当前是否存在连接
[oracle@wahaha3 admin]$ ps -ef | grep oraclewahaha3 | grep -v grep
说明这里的established只要连接过就会递增
Which two statements are true regarding the LISTENER2 listener? (Choose two.)
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
答案:BD
解析:
A:错误,UNKNOW 为静态 READY 为动态这里显示的是UNKNOW说明是静态
B:正确
C:错误,这个的意思是当前的连接是两个
D:正确,这个的意思是到目前为止共有2个连接
我们测试一下
Service "wahaha3" has 1 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
--这里显示的是0个
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
---连续连接3次,并且断开
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
--查看当前是否存在连接
[oracle@wahaha3 admin]$ ps -ef | grep oraclewahaha3 | grep -v grep
说明这里的established只要连接过就会递增
0 0
- 134.View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 l
- 148.View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that app
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo
- 91.View the Exhibit and examine the structure of the PROMOTIONS table. Which two SQL statements woul
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 86.View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true
- 117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
- 166.View the Exhibit and examine the setting for a table. Which statement is true about the PCTFR
- Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?
- 053-18 What two statements are true regarding the recommendations received from the SQL Access Advi
- 18 What two statements are true regarding the recommendations received from the SQL Access Advisor?
- 118.Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
- 117.View the Exhibit and examine the initialization parameter settings. Which three initialization p
- 【读书笔记】成员变量和局部变量(2)
- 【ZZULI】-1896-985的买饮料难题(思维)
- PAT-B 1055. 集体照
- Android关于RAM、ROM、SD卡以及各种内存的区别
- GCD问题--莫比乌斯反演
- 134.View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 l
- linux下生成coredump文件
- HDU 3410 Passing the Message
- 【团队-java-maven】在java项目中部署maven(2)关于java web的普通maven项目如何创建
- POJ:2485 Highways(最小生成树kruskal算法)
- webService
- Android 系统自带Activity效果
- opencv feature2D模块(二)
- ffmpeg与x264编码指南