74.Which statements are true regarding single row functions? (Choose all that apply.)

74.Which statements are true regarding single row functions? (Choose all that apply.)
A.MOD : returns the quotient of a division
B.TRUNC : can be used with NUMBER and DATE values
C.CONCAT : can be used to combine any number of values
D.SYSDATE : returns the database server current date and time
E.INSTR : can be used to find only the first occurrence of a character in a string
F.TRIM : can be used to remove all the occurrences of a character from a string
答案:BD
解析:问的是但行函数哪个正确
A:错误,mod返回的是余数
B:正确
C:错误,concat一次只能两个
D:正确
E:错误,instr(STR1 => , STR2 => , POS => , NTH => ),第三个参数为起始位置,第四个为第几次匹配
F:错误,trim,只能去掉,开头和结尾的单个字符

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值