(i) A table, ITEM has been created in a database with the following fields:
ITEMCODE, ITEMNAME, QTY, PRICE
Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.
(ii) Categorize the following commands into DDL and DML commands?
INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE…SET
Answer
(i) ALTER TABLE Item
ADD (Discount INT);
(ii ) DDL: DROP TABLE, ALTER TABLE
DML: INSERT INTO, UPDATE. ..SET