+1 vote
in Class 12 by kratos

Consider the Stu. table:

| Roll No. | Name |
| 1 | Ashi |
| 2 | Bimmi |
| 3 | Aakash |

The following SQL queries are **** on the

above table;

INSERT INTO Stu VALUES( *, 'Gagan');

COMMIT UPDATE Stu SET name='Abhi' WHERE

Rollno : 4

SAVEPOINT A;

INSERT INTO Stu VALUES(5,'Chris');

SAVEPOINT B;

INSERT INTO Stu VALUES(7,'Babita'); SAVEPOINT C;

ROLLBACK TO B;

What will be the output of the following SQL query now:

SELECT * FROM Stu;

1 Answer

+4 votes
by kratos
 
Best answer

1 Ashi

2 Bimmi

4 Abhi

5 Gagan

6 Chris

...