CBSE 2026 · Central · Set 4 · Q27 · 2 marks

Ms. Zoya is a Production Manager in a factory which packages mineral water. She decides to create a table in a database to keep track of the stock present in the factory. Each record of the table will have the following fields : W_Code - Code of the item (type - CHAR ($\displaystyle 5$)) W_Description - Description of the item (type - VARCHAR ($\displaystyle 20$)) B_Qty - Balance quantity of the item (type - INTEGER) U_Price - Unit Price of the item (type - FLOAT) The name of the table is W_STOCK.

(i)

(a)OR(b)

Write an SQL command to create the above table (W_Code should be the primary key).

(ii)

(a)OR(b)

Assuming that the table W_STOCK is already created, write an SQL command to add an attribute E_Date (of DATE type) to the table.

CREATE TABLE W_STOCK
(W_Code CHAR(5) PRIMARY KEY,
 W_Description VARCHAR (20),
 B_Qty INTEGER,          #OR B_Qty INT/B_Qty DECIMAL
 U_Price FLOAT);         #OR U_Price FLOAT(7,2)
                         #OR U_Price DECIMAL(7,2)

ALTER TABLE W_STOCK ADD COLUMN E_Date DATE;
ALTER TABLE W_STOCK ADD E_Date DATE;

ALTER TABLE W_STOCK DROP COLUMN B_Qty;
ALTER TABLE W_STOCK DROP B_Qty;

CBSE Class 12 Computer Science past-paper question from the 2026board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.