Subject: Distributed Databasebe

qs7

Consider the given STUDENT table

STUDENT

RegNo	Name	Address	Age	Contact No
173-NUN-0078	Ali	Nowshera	25	0333
182-NUN-0604	Usman	Swabi	23	0300
172-NUN-0708	Khalid	Peshawar	22	0321
191-NUN-0561	Waseem	Mardan	24	0300
191-NUN-8587	Tahir	Nowshera	26	0333
181-NUN-2030	Adnan	Peshawar	25	0321
162-NUN-7809	Bilal	Nowshera	25	0333

Apply the given commands on the above STUDENT table and also write the generated output.

1. Delete a record from the table where Address is Swabi without commit
2. Delete records from the table where Contact No is 0333 and commit
3. Insert any three records in the table and then rollback.
4. Insert two records in the table then commit and after commit rollback
5. Create a Savepoint SP1, SP2, SP3, and then insert two records after SP1, delete any record after SP2, insert a single record after SP3 and then rollback up to SP2.