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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!