1.

‘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?

Answer»

Output for the 1st SELECT * FROM Class ; statement -

RNONAME
5Rajeev
6Chris
7Feroze

Output for the llnd SELECT * FROM Class; statement

RNONAME
5Rajeev
6Chris


Discussion

No Comment Found

Related InterviewSolutions