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)