Question

A table named ITEM has the following contents:

ICODE	INAME	PRICE
101	STAIIONARY	100.00
102	COSMETICS	200.00

Write the output at the end of each SELECT statement

(i) SELECT * from ITEM;

SET AUTOCOMMIT = 0;

INSERT INTO ITEM VALUES (103,'GRO CERY',540.00);

(ii) SELECT * from ITEM; ROLLBACK

(iii) SELECT * FROM ITEM START TRNSACTION;

UPDATE ITEM SET PRICE = PRICE + 200; SAVE POINT S1;

UPDATE ITEM SET PRICE = PRICE + 400;

(iv) SELECT * FROM ITEM;

ROLLBACK TO S1;

(v) SELECT * FROM ITEM;

Answer 1

(i) 

ICODE	INAME	PRICE
101	STATIONARY	100.00
102	COSMETICS	200.00

(ii)

ICODE	NAME	PRICE
101	STATIONARY	100.00
102	COSMETICS	200.00
103	GROCERY	540.00

(iii)

ICODE	INAME	PRICE
101	STATIONARY	100.00
102	COSMETICS	200.00

(iv)

ICODE	INAME	PRICE
101	STATIONARY	700.00
102	COSMETICS	800.00

(v)

ICODE	INAME	PRICE
101	STATIONARY	300.00
102	COSMETICS	400.00