Evaluatethefollowingquery:SQL>SELECTTRUNC(ROUND(156.00,

单项选择题

Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）

A.16
B.100
C.160
D.200
E.150

相关考题

单项选择题 YouarecurrentlylocatedinSingaporeandhaveconnectedtoaremotedatabaseinChicago.Youissuethefollowingcommand:SQL>SELECTROUND(SYSDATE-promo_begin_date,0)FROMpromotionsWHERE(SYSDATE-promo_begin_date)/365>2;PROMOTIONSisthepublicsynonymforthepublicdatabaselinkforthePROMOTIONStable.Whatistheoutcome?（）

单项选择题 Whichstatementistrueregardingsubqueries?（）

多项选择题 WhichthreestatementsaretrueregardingthedatatypesinOracleDatabase10g/11g?（）

OCP 11G认证考试