Which function() accept arguments of any datatype?Select all that apply.(10分)
A. SUBSTR
B. NVL
C. ROUND
DECODE
E. SIGN
查看答案
What will be returned from SIGN(ABS(NVL(-23,0)))?
A. 1
B. 32
C. -1
D. 0
Which function could you use to strip leading characters from a character string? (10分)
A. LTRIM
B. SUBSTR
C. RTRIM
D. INSERT
E. MOD
Which line of code has an error?
A. SELECT dname, ename
B. FROM emp e, dept d
C. WHERE emp.deptno=dept.deptno
D. ORDER BY 1,2
Which of the following statements will not implicitly begin a transaction?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT FOR UPDATE
E. None of the above, they all implicitly begin a transaction.