Question: Consider the following Transaction LINE 1: INSERT INTO people VALUES (5, 'Ali'); LINE 2: COMMIT; LINE 3: UPDATE people SET name 'Khamis' WHERE id =

Consider the following Transaction LINE 1: INSERT INTO people VALUES (5, 'Ali'); LINE 2: COMMIT; LINE 3: UPDATE people SET name 'Khamis' WHERE id = '5'; LINE 4: SAVEPOINT A; LINE 5: INSERT INTO people VALUES (6, 'Fahad'); LINE 6: SAVEPOINT B; LINE 7: INSERT INTO people VALUES (7, 'Badriya'); LINE 8: SAVEPOINT C; LINE 9: SELECT * FROM people; If ROLLBACK is executed, to which line number the pointer will point
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
