RE: How to Test database in Manually? Explain with an example
Question : How to Test database in Manually? Explain with an example.
Ans : 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).
RE: How to Test database in Manually? Explain with an&...
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.
RE: How to Test database in Manually? Explain with an&...
hi nitya u can test DB in many ways and there are different approaches in Oracle and SQL erver 2005.Sql server is an easy approach to test ur DB. The simplest way is that You have SQL profiler in SQL server which lists down all the DB transaction done against the DB server once you are done with your application the just you can go and track down all the quires and SPs involved for your application and you can cross verify them in the quiery analizer.Or else ethere is a long process like U need to have acess to your webserver where in you can do some white box testing on the asp or jsp file and track down all the SPs or tables involved and then go to the DB manually verify all the SPs and track down where updations insertions deletions are done and then once you test ur application with test data agaian fire all the quires you tracked down you can find your data in DB.
RE: How to Test database in Manually? Explain with an&...
Database testing - manually can be done with the help of SQL queries. Now people might ask if we have to write queries. How is it manual in any way?
I say everyone & everything has a right or wrong perspective which one you choose is upto you. But generally DB testing is done by writing SQL queries and then validating those against the requirements.
I have seen guys checking data types manually by clicking and opening every table in SQL Server when this can be done by a simple select statement.
RE: How to Test database in Manually? Explain with an&...
Database testing is a process working with data that's stored in the database. If we change anything in the frontend and backend then what will the effect on the database. E.g. An table which has stored the records of students name roll no. class and sections etc. if we delete the students name in front end then what's effect in database. Wheather we test the student name deleted or not from database.
1 
0