PrepAway - Latest Free Exam Questions & Answers

which SQL statement needs to be used?

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?

PrepAway - Latest Free Exam Questions & Answers

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);

Explanation:


Leave a Reply