+1 vote
in Class 12 by kratos

Given below is the 'Department' table :

| DEPCODE | DEPNAME |
| 101 | ADMIN |
| 102 | RECEPTION |
| 103 | PERSONNEL |

SET AUTOCOMMIT = 0;

UPDATE Department SET DEPNAME = 'OFFICE' WHERE DEPNAME = 'ADMIN' ;

INSERT INTO Department SET DEPNAME = 'FRONT OFFICE' WHERE DEPNAME = 'RECEPTION';

COMMIT;

DELETE FROM Department WHERE DEPNAME = 'FRONT OFFICE';

ROLLBACK;

SELECT * FROM Department;

What will be the output of the above give SELECT statement ?

1 Answer

+3 votes
by kratos
 
Best answer

101 OFFICE

102 FRONT OFFICE

103 PERSONNEL

104 HRD

...