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;