违法和不良信息举报 联系客服
免费注册 登录

The current time zone for one of the user sessions is set to

题目
多选题
The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）
A

use the ALTER SYSTEM command to change the time zone

B

use the ALTER SESSION command to change the time zone

C

use the ALTER DATABASE command to change the time zone

D

set the value for the operating system variable ORA_SDTZ on the client machine

E

set the value for the operating system variable ORA_SDTZ on the database server machine

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）

  • A、Use the Database Resource Manager.
  • B、Set the limits in the profiles used by users.
  • C、Modify the SESSIONS initialization parameter.
  • D、Set the warning threshold for the Current Logons Count metric.

正确答案:D

第2题：

The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）

  • A、set the SESSIONS to 1 in the parameter file
  • B、grant SINGLE SESSION privilege to all of the users
  • C、set the SESSIONS_PER_USER to 1 in the users’ profile
  • D、grant RESTRICTED SESSION privilege to all of the database users
  • E、create a role with SINGLE SESSION privilege and assign the role to the users

正确答案:C

第3题：

View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()

A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error

B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued

C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .

D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention


参考答案：B, C

第4题：

You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

  • A、 The statistics are stored in the pending statistics table in the data dictionary.
  • B、 The statistics are treated as the current statistics by the optimizer for all sessions.
  • C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
  • D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

正确答案:A

第5题：

In the configuration shown in the exhibit， you decided to eliminate the junos-ftp applicationfrom the match condition of the policy MyTraffic. [edit security policies] user@hostl# show from-zone Private to-zone External { policy MyTraffic { match { source-address myHosts； destination-address ExtServers； application [ junos-ftp junos-bgp ]； } then { permit { tunnel { ipsec-vpn vpnTunnel； } } } } } policy-rematch； What will happen to the existing FTP and BGP sessions？（）

  • A、The existing FTP and BGP sessions will continue.
  • B、The existing FTP and BGP sessions will be re-evaluated and only FTP sessions will be dropped.
  • C、The existing FTP and BGP sessions will be re-evaluated and all sessions will be dropped.
  • D、The existing FTP sessions will continue and only the existing BGP sessions will be dropped.

正确答案:B

第6题：

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）

  • A、Set metric threshold
  • B、Implement Database Resource Manager
  • C、Enable resumable timeout for user sessions
  • D、Add directives to Automatic Database Diagnostic Monitor (ADDM)

正确答案:B

第7题：

In the exhibit， you decided to change myHosts addresses. [edit security policies] user@host# show from-zone Private to-zone External { policy MyTraffic { match { source-address myHosts； destination-address  ExtServers；application  [ junos-ftp junos-bgp ]； } then { permit { tunnel { ipsec-vpn vpnTunnel； } } } } } policy-rematch； What will happen to the new sessions matching the policy and in-progress sessions that hadalready matched the policy？（）

  • A、New sessions will be evaluated. In-progress sessions will be re-evaluated.
  • B、New sessions will be evaluated. All in-progress sessions will continue.
  • C、New sessions will be evaluated. All in-progress sessions will be dropped.
  • D、New sessions will halt until all in-progress sessions are re-evaluated. In-progress sessions will be re-evaluated and possibly dropped.

正确答案:A

第8题：

Click the Exhibit button.A network administrator receives complaints that the application voicecube is timing out after being idle for 30 minutes.Referring to the exhibit, what is a resolution?()

A. [edit] user@host# set applications application voicecube inactivity-timeout never

B. [edit] user@host# set applications application voicecube inactivity-timeout 2

C. [edit] user@host# set applications application voicecube destination-port 5060

D. [edit] user@host# set security policies from-zone trust to-zone trust policy intrazone then timeout never


参考答案：A

第9题：

You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

  • A、 A user table was lost at the specified time.
  • B、 A redo log file was lost at the specified time.
  • C、 The backup control file is on a faster disk than the current one.
  • D、 The current control file has a different path compared with the intended time of recovery.
  • E、 The current control file does not match the physical structure of the database at the intended time of recovery.

正确答案:E

第10题：

在SQL*PLUS中，显示执行时长的命令是（）

  • A、set time on
  • B、set timing on
  • C、set long
  • D、set timelong on
  • E、set sqlprompt

正确答案:B

更多相关问题
相关内容