73.Which tasks can be performed using SQL functions that are built into Oracle database ? (Choose three .)
A.finding the remainder of a division
B.adding a number to a date for a resultant date value
C.comparing two expressions to check whether they are equal
D.checking whether a specified character exists in a given string
E.removing trailing, leading, and embedded characters from a character string
答案:ACD
解析:
A:余数,mod
B:给日期增加指定的天数 add_months
C:比较两个表达式是否相等,nullif或者decode
D:指定字符是否存在,instr
E:从一个字符串的开头,结尾,中间移除字符,replace
感觉都对
A.finding the remainder of a division
B.adding a number to a date for a resultant date value
C.comparing two expressions to check whether they are equal
D.checking whether a specified character exists in a given string
E.removing trailing, leading, and embedded characters from a character string
答案:ACD
解析:
A:余数,mod
B:给日期增加指定的天数 add_months
C:比较两个表达式是否相等,nullif或者decode
D:指定字符是否存在,instr
E:从一个字符串的开头,结尾,中间移除字符,replace
感觉都对