IBM
C2090-610 · Question #99
C2090-610 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
Question
Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?
Options
- AALTER TABLE sales ADD COLUMN item CHAR(40);
- BALTER TABLE sales ALTER COLUMN item CHAR(40);
- CALTER TABLE sales MODIFY COLUMN item CHAR(40);
- DALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 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.