Which of the following is the best statement to use to create a user-defined data type that can be
used to store currency values?
A.
CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
B.
CREATE DISTINCT TYPE currency AS SMALLINT
C.
CREATE DISTINCT TYPE currency AS BIGINT
D.
CREATE DISTINCT TYPE currency AS DOUBLE
numeric(p,s) Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal.
0
0
A.
CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
0
0