网友您好, 请在下方输入框内输入要搜索的题目:
YouarecurrentlylocatedinSingaporeandhaveconnectedtoaremotedatabaseinChicago.Youissuethefollowingcommand:SQL>SELECTROUND(SYSDATE-promo_begin_date,0)FROMpromotionsWHERE(SYSDATE-promo_begin_date)/365>2;PROMOTIONSisthepublicsynonymforthepublicdatabaselinkforthePROMOTIONStable.Whatistheoutcome?()
A.anerrorbecausetheROUNDfunctionspecifiedisinvalid
B.anerrorbecausetheWHEREconditionspecifiedisinvalid
C.numberofdayssincethepromostartedbasedonthecurrentChicagodateandtime
D.numberofdayssincethepromostartedbasedonthecurrentSingaporedateandtime
参考答案