题目内容

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.

答案查题题库