Questions

1. How do we get the client time zone? Which function can be used?
   1. The SESSIONTIMEZONE function of the STANDARD package
   2. The MYTIMEZONE function of the STANDARD package
   3. The UTC_SHIFT function of the STANDARD package
   4. The DBTIMEZONE function of the STANDARD package
2. Choose the best option specifying the database time zone:
   1. TZH only
   2. TZH:TZM only
   3. Name representation only
   4. TZH:TZM and name representation
3. What data type is used for the column of the following select statement?

   select FROM_TZ(cast(sysdate as TIMESTAMP), '5:00')
                  AT TIME ZONE 'Europe/Brussels'
     from dual;

   1. DATE
   2. TIMESTAMP
   3. TIMESTAMP WITH TIME ZONE
   4. TIMESTAMP WITH LOCAL TIME ZONE
4. Which function takes three parameters – input timestamp values and the original and destination time zone to be calculated – applying the time shift for the input value?
   1. FROM_TZ
   2. NEW_TIME
   3. TIMESTAMP
   4. AT TIME ZONE
5. Which...