Quiz: Number Functions

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



Correct Correct


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 (*)



Correct Correct


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



Correct Correct


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



Correct Correct


( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )