多选题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 s

题目
多选题
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题:

Which of the following datatypes store time-zone information in the database?()

A. TIMESTAMP

B. DATE

C. TIMESTAMP WITH TIME ZONE

D. TIMESTAMP WITH LOCAL TIME ZONE

E. DATETIME


参考答案:C

第2题:

Two new servers are purchased and need to be installed to allow sharing of a single external hard drive enclosure.  One server is configured as a local file server, and the other as a database server for a different network.  The onsite technician notices that when both servers are running at the same time, they each receive SCSI errors. When they are running individually, no errors are reported.   Which of the following is the BEST source of information to use for troubleshooting this problem?()

  • A、 the server vendor’s FAQ website
  • B、 the SCSI controller vendor’s user manual
  • C、 the drive enclosure vendor’s user manual
  • D、 the network operating system vendor’s website

正确答案:C

第3题:

You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services, configuring name resolution and network access and so on. You are in charge of a domain controller that runs windows server 2008 and the DNS server role. The dns server hosts an active directory-integrated zone for your domain. You need to provide a user with the ability to manage records in the zone. But the user must not so what action should you perform?()

A.The user permissions on the zone should be granted.

B.The user permissions on the DNS zone should be granted.

C.The user should be added to the DNSUpdateProxy Global security group.

D.The user should be added to the DNSAdmins domain local security group.


参考答案:A

第4题:

For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()

  • A、 Set the CPU time per call in the users profile.
  • B、 Set the CPU time per session in the users profile.
  • C、 Set the CPU levels for the user’s group using Resource Manager.
  • D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

正确答案:C

第5题:

Your task is to provision the Junos security platform to permit transit packets from the Private zone to the External zone by using an IPsec VPN and log information at the time of session close.Which configuration meets this requirement?()

  • A、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts;destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; } } log { session-init; } } }
  • B、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; } } count { session-close; } } }
  • C、[edit security policies from-zone Private to-zone External] user@host# showpolicy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN;} } log { session-close; } } }
  • D、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; log; count session-close; } } } }

正确答案:C

第6题:

A user states that all their incoming mail is showing that it is behind three hours. All other users have the correct time. Which of the following should the technician check?()

  • A、The system’s local time settings
  • B、The system’s O/S version and patch status
  • C、The system’s network configuration
  • D、The mail server’s configuration

正确答案:A

第7题:

Which operational mode command can be used to synchronize the local system time with an NTP server?()

  • A、set ntp time 64.32.129.3
  • B、set clock ntp 64.32.129.3
  • C、set time 64.32.129.3
  • D、set date ntp 64.32.129.3

正确答案:D

第8题:

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

第9题:

Which of the following datatypes store time-zone information in the database?()

  • A、TIMESTAMP
  • B、DATE
  • C、TIMESTAMP WITH TIME ZONE
  • D、TIMESTAMP WITH LOCAL TIME ZONE
  • E、DATETIME

正确答案:C

第10题:

Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’;   What will be the result of issuing the above statement?()

  • A、 The statement will be executed successfully, and a new time zone will be set for the database.
  • B、 The statement will be executed successfully, but a new time zone will not be set for the database.
  • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
  • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

正确答案:D

更多相关问题