ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 221 discussion

Actual exam question from Oracle's 1z0-071
Question #: 221
Topic #: 1
[All 1z0-071 Questions]

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

  • A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
  • B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
  • C. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
  • D. The CURRENT_TIMESTAMP function returns data without time zone information.
  • E. A TIMESTAMP data type column contains information about year, month, and day.
Show Suggested Answer Hide Answer
Suggested Answer: BCE 🗳️
by Orakol at Feb. 27, 2023, 4:20 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Rafafm
8 months, 3 weeks ago
BCE be correct
upvoted 1 times
...
HUGO2024
10 months ago
Selected Answer: BCD
BCE should be correct
upvoted 1 times
...
Mcromeo
1 year, 6 months ago
Selected Answer: AC
ACE, B is false, it return only time zone name
upvoted 2 times
...
lucemqy
1 year, 7 months ago
Selected Answer: BCE
BCE should be correct
upvoted 1 times
Mcromeo
1 year, 6 months ago
B is false, it return only time zone name
upvoted 1 times
...
...
jm9999
1 year, 9 months ago
Selected Answer: ABC
To test A, I inserted rows from 2 different session time zones into a table using sysdate. The individual session time zones for each user session were recorded in the different rows. E is confusing because while true, that is not the only data that is recorded.
upvoted 1 times
jm9999
1 year, 8 months ago
I think correction BCE. For A the time zone used is the db time zone not the client session time zone.
upvoted 1 times
Misi_Oracle
1 year, 1 month ago
Time zone stored is based on the db time zone and will follow the time zone of the user the query it. Meaning A is wrong.
upvoted 1 times
...
...
...
WingL
1 year, 11 months ago
Selected Answer: BCE
I will follow BCE too.
upvoted 1 times
...
CMjer
2 years ago
Selected Answer: BCE
https://www.examtopics.com/discussions/oracle/view/8426-exam-1z0-071-topic-1-question-262-discussion/
upvoted 1 times
...
Orakol
2 years, 3 months ago
Selected Answer: BCE
I would say: BCE
upvoted 2 times
...
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.

SaveCancel