IBM
C2090-610 · Question #99
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?
The correct answer is D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40). See the full explanation below for the reasoning.
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);
How the community answered
(21 responses)- A5% (1)
- B5% (1)
- C10% (2)
- D81% (17)
Community Discussion
No community discussion yet for this question.