多项选择题
Which two statements are true regarding working with dates?（）
A.The default internal storage of dates is in the numeric format
B.The default internal storage of dates is in the character format
C.The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century
D.The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
相关考题
-
单项选择题
Evaluatethefollowingquery:SQL>SELECTTRUNC(ROUND(156.00,-1),-1)FROMDUAL;Whatwouldbetheoutcome?（）
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
