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

A table named 'GAMES' has the following contents:

GCode GameName Number of Player Prize Money
101 Carom Board 2 5000
102 Badminton 2 12000
103 Table Tennis 4 8000

Write the output that will be displayed by statements (i) and (ii).

SELECT * FROM GAMES; SET AUTOCOMMIT =0;

INSERT INTO GAMES VALUES(105,'CHESS" 2, 9000); ROLLBACK;

SAVEPOINT S1;

SELECT * FROM GAMES;   ... (i)

INSERT INTO GAMES VALUES(108, 'LAWN TENNIS" 4,25000);

SAVEPOINT S2;

INSERT INTO GAMES VALUES(109, 'CRICK ET' ,11,20000);

ROLLBACK TO S2;

SELECT * FROM ITEM   ...(ii)

1 Answer

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

(i) 

GCode GameName Number of Player Prize Money
101 Carom Board 2 5000
102 Badminton 2 12000
103 Table Tennis 4 8000

(ii)

CCode GameName Number of Player Prize Money
101 Carom Board 2 5000
102 Badminton 2 12000
103 Table Tennis 4 8000
104 Lawn Tennis 4 25000

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

...