Fewpal
0 votes
14 views
in Information Technology by (47.6k points)
closed by

Consider the Stu table ,

The following SQL queries are executed on the above table

INSERT INTO Stu VALUES (5. ‘Gagan’ ) ; COMMIT ;

UPDATE Stu SET NAME=‘Abhi’ WHERE ROLLNO = 4 SAVEPOINT A ;

INSERT INTO Stu VALUES (6 , ‘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

+1 vote
by (52.3k points)
selected by
 
Best answer

The output is

Related questions

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

...