InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
'Class' table has columns RNO and NAME.The following statements are executedSET 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');SAVEPOINT 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 first select statement :
|
|||||||||||||||