多項選擇題

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

你可能感興趣的試題

單項選擇題

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

單項選擇題

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

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which two statements are true regarding working with dates?（）

你可能感興趣的試題

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