Question: The following sequence of SQL commands are issued: create table dummy(name varchar(20), Description varchar(200)); start transaction; savepoint alpha; insert into dummy (name, description) values (Bozo,

The following sequence of SQL commands are issued:

create table dummy(name varchar(20), Description varchar(200));

start transaction;

savepoint alpha;

insert into dummy (name, description) values (Bozo, A clown), (Junior, Bozos assistant);

savepoint alpha;

insert into dummy (name, description) values (Felix, A notable cat indeed), (Gumby, One really flexible guy);

savepoint beta;

delete from dummy;

select count(*)

from dummy;

rollback work to savepoint alpha;

select count(*)

from dummy;

There are two select statements in this sequence. What is the count that you will get in return from each of them, and why?

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!