Which of the following SQL statements can be used to create a DB2 object to store numerical data
as EURO data?
A.
CREATE NICKNAME euro FOR DECIMAL (9,3)
B.
CREATE ALIAS euro FOR DECIMAL (9,3)
C.
CREATE DISTINCT TYPE euro AS DECIMAL (9,3)
D.
CREATE DATA TYPE euro AS DECIMAL (9,3)
A distinct type is a user-defined data type that shares its internal representation with a built-in data type (its source type), but is considered to be a separate and incompatible data type for most operations.
For example, the semantics for a picture type, a text type, and an audio type that all use the built-in data type BLOB for their internal representation are quite different. A distinct type is created with the SQL statement CREATE TYPE.
For example, the following statement creates a distinct type named AUDIO:
CREATE TYPE AUDIO AS BLOB (1M);
0
0