‘Class’ table has columns RNO and NAME. The following statements are executed:
SET AUTOCOMMIT = 0 :
INSERT INTO CLASS VALUES (5, ‘Rajiv’) :
COMMIT ;
UPDATE CLASS SET NAME = ‘Rajeev’
WHERE ID = 5 ;
SAVEPOINT A ;
INSERT INTO CLASS VALUES (6, ‘Chris’) ;
SAVE POINT B ;
INSERT INTO CLASS VALUES (7, ‘Feroze’) ;
SELECT * FROM CLASS ;
ROLLBACK TO B ;
SELECT * FROM CLASS ;
What will be the output of both the above given SELECT statements?
