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?
A. ALTER TABLE sales ADD COLUMN item CHAR(40);
B. ALTER TABLE sales ALTER COLUMN item CHAR(40);
C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);
D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
|
Download Printable PDF. VALID exam to help you PASS. |
 |