Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students explore these related Databases questions

Question

8. Satyam Computer Services Limited

Answered: 3 weeks ago

Question

7. General Mills

Answered: 3 weeks ago