Question: 1 7 . ( 2 pts ) Examine ( but do not execute ) the following block. If this block were run, what data would

17.(2 pts) Examine (but do not execute) the following block. If this block were run, what data would be saved in the database?
BEGIN
INSERT INTO endangered_species
VALUES (400, 'Blue Gound Beetle', 'Carabus intricatus');
SAVEPOINT sp_400;
INSERT INTO endangered_species
VALUES (500, 'Little Spotted Cat', 'Leopardus tigrinus');
ROLLBACK;
INSERT INTO endangered_species
VALUES (600, 'Veined Tongue-Fern', 'Elaphoglossum nervosum');
ROLLBACK TO sp_400;
END;

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 Programming Questions!