+2 votes
in Class 12 by kratos

Given below is the 'Stu' table :

| RNO | NAME |
| 1 | Amit |
| 2 | Bhishm |

The following statements are entered :

SET AUTOCOMMIT = 0;

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

COMMIT;

UPDATE Stu set name='Rahuliya' where Rno =5;

SAVEPOINT A;

INSERT INTO Stu VALUES(6, 'Cristina');

SAVEPOINT B;

INSERT INTO Stu VALUES(7, 'Fauzia');

SAVEPOINT C;

ROLLABCK TO B;

Now, what will be the output of the following statement ?

SELECT * FROM Stu;

1 Answer

+4 votes
by kratos
 
Best answer

| RNO | NAME |
| 1 | Amit |
| 2 | Bhishm |
| 3 | Rahuliya |
| 4 | Cristina |

...