137. Which three possible values can be set for the TIME_ZONE session

parameter by using the ALTER SESSION command? (Choose three.)

A. 'os'

B. local

C. '-8:00'

D. dbtimezone

E. 'Australia'

Answer: BCD

E选项不是时区

The session time zone can be set to:

- O/S local time zone

- Database time zone

- An absolute offset

- A named region

1. The first method consists to use one of the following ALTER SESSION SET

TIME_ZONE statements:

SQL> ALTER SESSION SET TIME_ZONE = local;

SQL> ALTER SESSION SET TIME_ZONE = dbtimezone;

SQL> ALTER SESSION SET TIME_ZONE = '-05:00';

SQL> ALTER SESSION SET TIME_ZONE = 'Europe/London';

ITPub博客

047-137