+1 vote
in Class 12 by kratos

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

+2 votes
by kratos
 
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 |

...