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

来源:互联网 发布:访客网络怎么开启 编辑:程序博客网 时间:2024/06/11 08:06
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,只能去掉,开头和结尾的单个字符

0 0