IBM
C2090-312 · Question #195
C2090-312 Question #195: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #195. The question stem and answer options stay visible for context.
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
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.