Multiple choice technology databases

The current time in Dubai is 04-APR-2008 08:50:00, and the time in Dallas is 03-APR-2008 23:50:00. A user from Dubai is connected to a session in the database located on a server in Dallas. What will be the result of his query?

  1. 04?APR?2008 08:50:00

  2. 03?APR?2008 23:50:00

  3. 03?APR?2008 2324:50:00

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle date functions like SYSDATE return the database server's system date and time, not the client's local time. Since the database server is in Dallas, it returns Dallas time (03-APR-2008 23:50:00) regardless of user's Dubai location.

Keep practicing — related questions