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
...
...
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
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
7 months, 1 week agolucemqy
1 year, 1 month agojm9999
1 year, 2 months agomusafir
1 year, 6 months agoSantiBZ_07032022_1744
1 year, 10 months agoDarnun
1 year, 9 months ago