043-010

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

database local time zone. For one application, the user session requi

res the time zone to be set to the local operating system time zone w

ithout affecting other user sessions.

Which two solutions could the user implement to achieve this objectiv

e? (Choose two.)

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 cl

ient machine

E. set the value for the operating system variable ORA_SDTZ on the da

tabase server machine

Answer: B, D

对于一个应用，在你的回话中你想设定本地操作系统时间，而不影响其它的回话，

a、你需要使用 alter session 修改该会话的时间

b、在客户机上修改操作系统的参数ORA_SDTZ

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-717624/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-717624/