IBM
C2090-610 · Question #51
Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?
The correct answer is B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS. See the full explanation below for the reasoning.
Question
Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?
Options
- ACREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- BCREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- CCREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- DCREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
How the community answered
(29 responses)- A14% (4)
- B76% (22)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.