You are currently located in Singapore and have connected to a remote database in Chicago.
You issue the following command:
SQL> SELECT ROUND(SYSDATE-promo_begin_date,0)
FROM promotions
WHERE (SYSDATE-promo_begin_date)/365 > 2;
PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?
A.
a n error because the ROUND function specified is invalid
B.
a n error because the WHERE condition specified is invalid
C.
n umber of days since the promo started based on the current Chicago date and time
D.
number of days since the promo started based on the current Singapore date and time
Its c because the server is based in chicago, so the date will be based on where the server is located at.
thanks for your info .
That’s not true. Most companies servers are setup to use universal time, GMT.
It means Chicago Server date and time, whatever it is set to.
Muchos Gracias for your article post.Thanks Again. Will read on…
Wow! this cartoon type YouTube video I have seen when I was in primary level and at the present I am in academy and watching that again here.