+2 votes
in Class 12 by kratos

A table named 'LIBRARY' has the following. Contexts :

| Bcode | Book Name | Pages | Price |
| A112 | computer | 250 | 200 |
| A114 | English | 300 | 250 |
| A080 | Mathematics | 500 | 400 |

SET AUTOCOMMIT = O;

INSERT INTO LIBRARY VALUES ('A110', 'Science', 200,200);

ROLLBACK

SAVEPOINT S1;

SELECT * FROM LIBRARY;

INSERT INTO LIBRARY VALUES (A113' 'Chemistry', 300, 350);

SAVEPOINT S2;

INSERT INTO LIBRARY VALUES (A115' 'History' 250,200)

(i) ROLLBACK TO S2;

(ii) SELECT * FROM LIBRARY;

1 Answer

+2 votes
by kratos
 
Best answer

(i)

| Bcode | Book Nane | Pages | Price |
| A112 | Computer | 250 | 250 |
| A114 | English | 300 | 250 |
| A080 | Mathematics | 500 | 400 |

(ii)

| Bcode | Book Name | Pages | Price |
| A112 | Computer | 250 | 200 |
| A114 | English | 300 | 250 |
| A080 | Mathematics | 500 | 400 |
| A113 | Chemistry | 300 | 350 |

...