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
Get step-by-step solutions from verified subject matter experts
