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,只能去掉,开头和结尾的单个字符
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
- 74.Which statements are true regarding single row functions? (Choose all that apply.)
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 41 Which statements are true regarding table compression? (Choose all that apply.) A. It saves disk
- 148.View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that app
- 46.Which statements are correct regarding indexes? (Choose all that apply.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 42.Which three statements are true regarding views? (Choose three.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 135.Which three statements are true regarding subqueries? (Choose three.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- 174.Which statement is true regarding transactions? (Choose all that apply.)
- 158.Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all tha
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- ffmpeg的php扩展 在64位系统下的安装
- Linux tcpdump命令详解
- google可用host3月2日
- Iptables之FORWARD转发链
- 内存优化学习
- 74.Which statements are true regarding single row functions? (Choose all that apply.)
- scala对时间(date)字符串转化为时间戳timestamp的实现
- Maven依赖排除 禁止依赖传递 取消依赖的方法
- Find the Kth number c++ version
- vim字符串查找
- java-String类深入剖析和 intern()方法解析
- C++中在容器Vector中使用结构体Struct
- ArrayUtils学习
- CSS绘制各种形状