IBM
C2090-312 · Question #195
Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and…
The correct answer is A. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS. See the full explanation below for the reasoning.
Question
Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?
Options
- ACREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS
- BCREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS
- CCREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS
- DCREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS
How the community answered
(33 responses)- A70% (23)
- B18% (6)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.