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

The correct answer is B. SELECT TO CHAR (2000, `$0,000.00') C. SELECT TO CHAR (2000, `$9,999.00') D. SELECT TO CHAR (2000, `$9,999.99'). 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. E: Oracle error "ORA-01481: invalid number format model" will be generated. F: Oracle error…

Monitor and Troubleshoot a XenDesktop 7 Environment

Question

Options

ASELECT TO CHAR (2000,`$#,###.##')
BSELECT TO CHAR (2000, `$0,000.00')
CSELECT TO CHAR (2000, `$9,999.00')
DSELECT TO CHAR (2000, `$9,999.99')
ESELECT TO CHAR (2000, `$2,000.00')
FSELECT TO CHAR (2000, `$N,NNN.NN')

How the community answered

(24 responses)

A
4% (1)
B
79% (19)
E
13% (3)
F
4% (1)

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. E: Oracle error "ORA-01481: invalid number format model" will be generated. F: Oracle error "ORA-01481: invalid number format model" will be generated.

Topics

#SQL TO_CHAR#number formatting#Oracle functions#SQL formatting

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice