Register Login

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

Updated May 18, 2018

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

A. SELECT TO_CHAR(2000, '$#,###.##')
FROM dual;

B. SELECT TO_CHAR(2000, '$0,000.00')
FROM dual;

C. SELECT TO_CHAR(2000, '$9,999.00')
FROM dual;

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

E. SELECT TO_CHAR(2000, '$2,000.00')
FROM dual;

F. SELECT TO_CHAR(2000, '$N,NNN.NN')
FROM dual;

ANS: BCD


×