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
1.6k views
in Computer by (79.0k points)

'Class' table has columns RNO and NAME.

The following statements are executed

SET AUTOCOMMIT = 0;

INSERT INTO CLASS VALUES (5, 'Rajiv'); COMMIT;

UPDATE CLASS SET NAME = 'Rajeev' WHERE ID = 5;

SAVEPOINT A;

INSERT INTO CLASS VALUES (6, 'Chris'); SAVEPOINTB;

INSERT INTO CLASS VALUES (7, 'Feroze'); SELECT * FROM CLASS;

ROLLBACK TO B;

SELECT * FROM CLASS;

What will be the output of both the above given SELECT statements ?

1 Answer

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

(Case 1 : If RNO is treated as ID, the following solution should be accepted:)

Output of SELECT statement 1 :

RNO NAME
5 Rajeev
6 Chris
7 Feroze

Output of SELECT statement 2 :

RNO NAME
5 Rajeev
6 Chris

(Case 2 : If RNO is NOT treated as ID, the following should be accepted:)

Output of SELECT statement 1 :

RNO NAME
5 Rajeev
6 Chris
7 Feroz

Output of SELECT statement 2 :

RNO NAME
5 Rajeev
6 Chris

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

...