This depends on the front-end application’s interface which is being used. We can test by using the following ways :
Check for the updated data in the front-end application’s view. The view should be updated with the new value post successful insertion. This kind of testing constitutes black box testing.
If there is no view available, then we can go to the database system, run the select query and check for the data manually.
We can also use the WinRunner or QTP for checking the database update.
