Exam 1z0-082 topic 1 question 68 discussion

C D E: "TIMESTAMP WITH LOCAL TIME ZONE is another variant of TIMESTAMP that is sensitive to time zone information. It differs from TIMESTAMP WITH TIME ZONE in that data stored in the database is normalized to the database time zone, and the time zone information is not stored as part of the column data. When a user retrieves the data, Oracle returns it in the user's local session time zone." So, the data is stored with the DB Timezone, even if it's retrieved with the session timezone. A is clearly wrong by example, so the rest are true. With D and E we can also have an easy sample, while for C, which is apparently the most ambiguous, I agree with whom was saying that the TIMESTAMP data type contains indeed informations about day, month and year, and in the answer is never stated that they are the only ones present. So as it's put, it's definitely right. https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#GUID-CD2954CE-45E2-4938-A599-CCB96879510F

B is true for "TIMESTAMP WITH TIMEZONE" not for "TIMESTAMP WITH LOCAL TIMEZONE". So C is the next best as tit contains yy mm dd though it ALSO contains time information

Provided answers are wrong, by exclusion: A. The CURRENT_TIMESTAMP function returns data without time zone information -->False, it is returned. B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row C. A TIMESTAMP data type column contains information about year, month, and day --> False, incomplete sentence. D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

C is wrong. The TIMESTAMP datatype is an extension of the DATE datatype. It stores a year, month, day, hour, minute, and second values. It also stores fractional seconds, which are not stored by the DATE datatype. https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#:~:text=The%20TIMESTAMP%20datatype%20is%20an,stored%20by%20the%20DATE%20datatype.

(CDE) IAM SURE!!

B IS wrong. TIMESTAMP WITH LOCAL TIME ZONE Data Type TIMESTAMP WITH LOCAL TIME ZONE is another variant of TIMESTAMP. It differs from TIMESTAMP WITH TIME ZONE as follows: data stored in the database is normalized to the database time zone, and the time zone offset is not stored as part of the column data. so session time zone must transform .

B, is only right if you supply the offset . Here is the test . Still B ? any thoughts? alter session set time_zone='-7:00'; SQL> desc test3 Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER TIMES1 TIMESTAMP(6) WITH LOCAL TIME ZONE insert into test3 values (8, TIMESTAMP '2020-07-01 2:00:00 -8:00'); insert into test3 values (9,TIMESTAMP '2020-07-01 2:00:00'); SQL> select id,times1 from test3 where id in (8,9); ID ---------- TIMES1 --------------------------------------------------------------------------- 8 01-JUL-20 03.00.00.000000 AM 9 01-JUL-20 02.00.00.000000 AM

i still believe B, D, E are correct.. C is wrong because The TIMESTAMP data type allows you to store date and time data including year, month, day, hour, minute and second.

D is correct > SQL> select DBTIMEZONE from dual; DBTIME ------ +01:00

Correct Answer: BCD Wrong Answer: AE https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#NLSPG004 CURRENT_TIMESTAMP Returns the current date and time in the session time zone as a TIMESTAMP WITH TIME ZONE value select CURRENT_TIMESTAMP from dual; -- CURRENT_TIMESTAMP -- 28-JUL-20 09.56.37.618148000 AM AMERICA/LOS_ANGELES DBTIMEZONE Returns the value of the database time zone. The value is a time zone offset or a time zone region name SESSIONTIMEZONE Returns the value of the current session's time zone SELECT sessiontimezone FROM DUAL; -- SESSIONTIMEZONE -- America/Los_Angeles B is driving me crazy, but AE are wrong, so ...

A is wrong SQL> select CURRENT_TIMESTAMP from dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 23.07.20 12:18:00,735965 +02:00

B & C & E is correct answer

C D E i think