YouarecurrentlylocatedinSingaporeandhaveconnectedtoaremotedatabaseinChicago.Youissuethefollowingcommand:SQL>SELECTROUND(SYSDATE-promo_begin_date,0)FROMpromotionsWHERE(SYSDATE-promo_begin_date)/365>2;PROMOTIONSisthepublicsynonymforthepublicdatabaselinkfort
题目
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
相似考题
参考答案和解析
参考答案：C