You are currently located in Singapore and have connected to a remote database in Chicago.
You issue the following command:
PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?
A.
Number of days since the promo started based on the current Singapore data and time.
B.
An error because the ROUND function specified is invalid
C.
An error because the WHERE condition specified is invalid
D.
Number of days since the promo started based on the current Chicago data and time
I think the right answer is B i did this to check:
select round(sysdate,0)
from dual;
And I got an error:
RA-00932: inconsistent datatypes: expected DATE got NUMBER
The math operation between two dates results in number data type.
Sorry I found my error
select round(sysdate-to_date(’11-jan-2013′),0)
from dual;
works therefore D is the right answer