How to Test database in Manually?

hpdynasty

Observing that opertaions, which are operated on front-end is effected on back-end or not.
The approach is as follows :
While adding a record thr' front-end check back-end that addition of record is effected or not.
So same for delete, update,......

Ex:Enter employee record in database thr' front-end and check if the record is added or not to the back-end(manually).
Database can be tested various ways,

If we are usein SQL server then opne the SQL query analyzer and write the queries to retrieve the data. Then verify whether the expected result is correct or not. IF not the data is not inserted into database.

We can play with queries to insert, update and delete the data from the data base and check in the front end of the application.

IF it is Oracle then open the SQL plus and follow the same procedure. Most of the time we find invalid data.

Same way we can test the stored procedure in sql query analyzer and check the result
How to test means , Through SQL quary we can test manually, how , i will tell see the below exmple with out using check point we can test.

1)connect to the database
db_connect("query1",DRIVER={drivername};SERVER=server_name;UID=uidnameWD=password;DBQ=database_name ");

2)Execute the query
db_excecute_query("query1","write query u want to execute");
-Condition to be mentioned-

3)disconnect the connection
db_disconnect("query");