Which three possible values can be set for the TIME_ZONE session parameter by using the
ALTER SESSION command? (Choose three.)
A.
local
B.
-8:00′
C.
dbtimezone Li
D.
‘Australia’
E.
‘os’
Which three possible values can be set for the TIME_ZONE session parameter by using the
ALTER SESSION command? (Choose three.)
Which three possible values can be set for the TIME_ZONE session parameter by using the
ALTER SESSION command? (Choose three.)
A.
local
B.
-8:00′
C.
dbtimezone Li
D.
‘Australia’
E.
‘os’
D also correct you can set a named region as well
Australia is the whole continent. There are different time zones. D is wrong.
local is a dbtimezone parameter.
hello, are these question still valid?
A,B,C
https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm
questions are still valid.About 75% of questions will be in the real exam.
Example o an addiional questions:
How to find difference in time between the ‘AMERICA/NEW_YORK’ TZ and UTC.
A. SELECT TO_TIMESTAMP_TZ(‘AMERICA/NEW_YORK’) FROM dual;
B. SELECT TO_YMINTERVAL(‘AMERICA/NEW_YORK’) FROM dual;
C. SELECT FROM_TZ(‘AMERICA/NEW_YORK’) FROM dual;
D. SELECT TZ_OFFSET(‘AMERICA/NEW_YORK’) FROM dual;
SELECT hire_date, last_name, salary, LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal from employees
WHERE job_id = ‘SA_MAN’ ORDER BY hire_date;
A. It displays salesman who were hired in the current month and have not drawn any salary.
B. It fails because of the GROUP BY clause is not used.
C. It fails because the ORDER BY clause at the end should not be used with the LAG … OVER function.
D. It displays the hire_date, last_name and salary values of each salesman along with the SALARY value of each salesman hired before them.
E. It displays each salesman and the SALARY values of each salesman and SALARY value of the employee hired just after each salesman.
The paragraph below is from the Oracle Document.
You can change the time zone for a specific SQL session with the SET TIME_ZONE clause of the ALTER SESSION statement.
TIME_ZONE can be set to the following values:
Default local time zone when the session was started (local) – A
Database time zone (dbtimezone) – C
Absolute offset from UTC (for example, ‘+10:00’) – B
Time zone region name (for example, ‘Asia/Hong_Kong’)