Test: Quiz: Number Functions
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. What is the result of the following SQL Statement:
SELECT ROUND(45.923,-1)
FROM DUAL;
Mark for Review
(1) Points
46
45.9
50 (*)
None of the above
2. The answer to the following script is 456. True or False?
SELECT TRUNC(ROUND(456.98))
FROM dual
Mark for Review
(1) Points
True
False (*)
3. ROUND and TRUNC functions can be used with which of the following Datatypes? Mark for Review
(1) Points
Dates and numbers (*)
Dates and characters
Numbers and characters
None of the above
4. Which number function may be used to determine if a value is odd or even? Mark for Review
(1) Points
MOD (*)
TRUNC
ROUND
BINARY
