Which three SELECT statements display 2000 in the format "$2,000.00"?

Which three SELECT statements display 2000 in the format “$2,000.00”? (Choose three.)

A.
SELECT TO_CHAR(2000, ‘$N,NNN.NN’)
FROM dual;

B.
SELECT TO_CHAR(2000, ‘$9,999.00’)
FROM dual;

C.
SELECT TO_CHAR(2000, ‘$#,###.##’)
FROM dual;

D.
SELECT TO_CHAR(2000, ‘$9,999.99’)
FROM dual;

E.
SELECT TO_CHAR(2000, ‘$0,000.00’)
FROM dual;

F.
SELECT TO_CHAR(2000, ‘$2,000.00’)
FROM dual;

Explanation:

Only queries in answers B, C and D will show result as in the format “$2,000.00”.
Incorrect Answers:
A: Oracle error “ORA-01481: invalid number format model” will be generated.
F: Oracle error “ORA-01481: invalid number format model” will be generated.OCP Introduction to
Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365Chapter 8: User Access Control in
Oracle