choose two In the PROMOTioNS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date fORMat is DD-M
choose two
In the PROMOTioNS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date fORMat is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a queny?
A) TO_NUMBER(PROMO_ BEGIN_DATE) - 5 will return number
B) TO_DATE(PROMO_BEGIN_DATE * 5) will return a date
C) PROMO_BEGIN_DATE - SYSDATE will return a number.
D) PROMO_BEGIN_DATE - 5 will return a date.
E) PROMO_BEGIN_DATE - SYSDATE will return an error.
Answer:CD
(解析:这道题考的还比较有意义,AAnswer:错是因为日期型的不能转换为 number;日期不能乘除某个数,所以 BAnswer:错;但是日期型的是可以进行加减。)
--结束END--
本文标题: 【2019年8月】OCP 071认证考试最新版本的考试原题-第21题
本文链接: https://www.lsjlt.com/news/1826.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0