A seems 100%. B is correct if you consider timestamp as the overarching data type of timestamp with time zone and timestamp with local time zone. However if D says current_date then I like AD over AB.
select tzname, tz_offset(tzname) from v$timezone_names;
select tzname, tz_offset(tzname) from v$timezone_names
where tzname = 'America/Anchorage';
alter session set time_zone='America/Anchorage';
select sessiontimezone, current_timestamp, dbtimezone, systimestamp from dual;
select current_time from dual;
A → OK.
B → NOOK: Returns TIMESTAMP WITH TIME ZONE.
C → NOOK: No, in the SESSIONTIMEZONE..
D → CURRENT_TIME doesn’t exist.
E → NOOK: No, in the SESSIONTIMEZONE.
F → NOOK. SYSTIMESTMP returns date based on DBSTIMEZONE.
Checked on my own, got the same conclusions. Not sure which ones are correct then
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RIDA_007
1 month, 2 weeks agolucemqy
7 months, 3 weeks agojm9999
8 months, 4 weeks agomusafir
1 year agoSantiBZ_07032022_1744
1 year, 4 months agoDarnun
1 year, 3 months ago