Oracle
1Z0-071 · Question #151
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
The correct answer is A. SELECT TO_CHAR (1890.55, '$99G999D00') C. SELECT TO_CHAR (1890.55, '$0G000D00') E. SELECT TO_CHAR (1890.55, '$99G999D99'). See the full explanation below for the reasoning.
Question
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
Options
- ASELECT TO_CHAR (1890.55, '$99G999D00')
- BSELECT TO_CHAR (1890.55, '$9,999V99')
- CSELECT TO_CHAR (1890.55, '$0G000D00')
- DSELECT TO_CHAR (1890.55, '$99,999D99')
- ESELECT TO_CHAR (1890.55, '$99G999D99')
How the community answered
(15 responses)- A73% (11)
- B20% (3)
- D7% (1)
Community Discussion
No community discussion yet for this question.