+2 votes
in Class 12 by kratos

Given below is the 'Emp' table :

| ENO | NAME |
| 1 | Anita Khanna |
| 2 | Bishmeet Singh |

The following Statements are entered :

SET AUTOCOMMIT = 0;

INSERT INTO Emp VALUES (5,'Farzia');

COMMIT;

UPDATE Emp SET NAME ='Farzziya' WHERE

ENO=5;

SAVEPOINT A;

INSERT INTO EmP VALUES(6,'Richard');

SAVEPOINT B;

INSERT INTO Emp VALUES(7,'Rajyalakshmi');

SAVEPOINT C;

ROLLBACK TO B;

What will be that output of the following SQL query now?

SELECT * FROM EmP;

1 Answer

+1 vote
by kratos
 
Best answer

| ENO | NAME |
| 1 | Anita Khanna |
| 2 | Bishmeet Singh |
| 3 | Farzziya |
| 4 | Richard |

...