单项选择题
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?（）
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 -
单项选择题
Whichstatementistrueregardingsubqueries?（）
A.The LIKE operator cannot be used with single-row subqueries
B.The NOT IN operator is equivalent to IS NULL with single-row subqueries
C.=ANY and =ALL operators have the same functionality in multiple-row subqueries
D.The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries -
多项选择题
WhichthreestatementsaretrueregardingthedatatypesinOracleDatabase10g/11g?（）
A.Only one LONG column can be used per table
B.A TIMESTAMP data type column stores only time values with fractional seconds
C.The BLOB data type column is used to store binary data in an operating system file
D.The minimum column width that can be specified for a VARCHAR2 data type column is one
E.The value for a CHAR data type column is blank-padded to the maximum defined column width
