Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.2k views
in Computer by (79.3k points)

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 (76.4k points)
selected by
 
Best answer
ENO NAME
1 Anita Khanna
2 Bishmeet Singh
3 Farzziya
4 Richard

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...