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
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started