1.
Which statements regarding single-row functions are true? (Choose
all that apply.)
a. They may return more
than one result.
b. They execute once for each
record processed.
c. They may have zero or
more input parameters.
d. They must have at least
one mandatory parameter.
2.
Which of these are single-row character-case conversion functions?
(Choose all that apply.)
a. LOWER
b. SMALLER
c. INITCASE
d. INITCAP
3.
What value is returned after executing the following statement:
SELECT LENGTH('How_long_is_a_piece_of_string?') FROM DUAL;
(Choose the best answer.)
a. 29
b. 30
c. 24
d. None of the above
4.
What value is returned after executing the following statement:
SELECT SUBSTR('How_long_is_a_piece_of_string?', 5,4) FROM DUAL;
(Choose the best answer.)
a. Long
b. _long
c. String
d. None of the above
5.
What value is returned after
executing the following statement?
SELECT INSTR('How_long_is_a_piece_of_string?','_',5,3) FROM
DUAL;
(Choose the best answer.)
a. 4
b. 14
c. 12
d. None of the above
6.
What value is returned after executing the following statement?
SELECT REPLACE('How_long_is_a_piece_of_string?','_','') FROM
DUAL;
(Choose the best answer.)
a. How long is a piece of
string?
b. How_long_is_a_piece_of_string?
c. Howlongisapieceofstring?
d. None of the above
7.
What value is returned after executing the following statement?
SELECT MOD(14,3) FROM DUAL; (Choose the best answer.)
a. 3
b. 42
c. 2
d. None of the above
8.
Assuming SYSDATE=07-JUN-1996 12:05pm, what value is returned after
executing the
following statement?
SELECT ADD_MONTHS(SYSDATE,-1) FROM DUAL; (Choose the best
answer.)
a. 07-MAY-1996 12:05pm
b. 06-JUN-1996 12:05pm
c. 07-JUL-1996 12:05pm
d. None of the above
9.
What value is returned after executing the following statement?
Take note that 01-JAN-2009 occurs on a Thursday. (Choose the best
answer.)
SELECT NEXT_DAY('01-JAN-2009','wed') FROM DUAL;
a. 07-JAN-2009
b. 31-JAN-2009
c. Wednesday
d. None of the above
10.
Assuming SYSDATE=30-DEC-2007,
what value is returned after executing the following
statement?
SELECT TRUNC(SYSDATE,'YEAR') FROM DUAL; (Choose the best
answer.)
a. 31-DEC-2007
b. 01-JAN-2008
c. 01-JAN-2007
d. None of the above