Question

(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 following commands into DDL and DML commands? 

INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE...SET

Answer 1

(i)   ALTER TABLE Item

      ADD (Discount INT);

(ii ) DDL: DROP TABLE, ALTER TABLE 

      DML: INSERT INTO, UPDATE. ..SET