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

Step: 3

blur-text-image

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

SQL Database Programming

Authors: Chris Fehily

1st Edition

1937842312, 978-1937842314

More Books

Students also viewed these Databases questions