多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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、an error because the ROUND function specified is invalid 
  • B、an error because the WHERE condition specified is invalid 
  • C、number 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 
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题