Exam 1z0-061 topic 1 question 11 discussion

ADE 0 Returns leading zeros./ Returns trailing zeros. 9 Returns value with the specified number of digits with a leading space if positive or with a leading minus if negative. Leading zeros are blank, except for a zero value, which returns a zero for the integer part of the fixed-point number. G Returns in the specified position the group separator (the current value of the NLS_NUMERIC_CHARACTER parameter). You can specify multiple group separators in a number format model.Restriction: A group separator cannot appear to the right of a decimal character or period in a number format model. V Returns a value multiplied by 10n (and if necessary, round it up), where n is the number of 9's after the V.

the question ask for 1,890.55 but the A,C and D option gives the result that 1.890,55 If this correct, the right aswers A,C and D. otherwise none of them is corrent.

Please correct this Question.

ADE correct

select to_char(1890.55,'$0G000D00') from dual; --correct select to_char(1890.55,'$9,999V99') from dual; --incorrect select to_char(1890.55,'$99,999D99') from dual; --ora-01481 "invalid number format model" select to_char(1890.55,'$99G999D00') from dual; --correct select to_char(1890.55,'$99G999D99') from dual; --correct

C is not correct....

This question is wrong. it says which three statements, it should rather which four statements. A C D E are all the correct answers. this only gave A D answers.

Questions asks for "3" answers...wouldn't "E" be correct as well?