How to test the database manual? how to test data base
lekage by using manual and also using QTP ?

Answers were Sorted based on User's Feedback

How to test the database manual? how to test data base lekage by using manual and also using QTP ?..

Answer / rajendra

Manual Database Testing:
every application will have an user interface page to enter
the data.
Actually what we enter the data in front end will be stored
in the back end database.
In this process od database testing we will enter some test
data from front end.
We will check the data stored in to the database with the
test data which we entered from the front end.

If the database is working fine then the data entered from
the front end must be same as the data present in the

To start actual database testing testers normally login in
to database using User name and password.

More than this we should check the database constarints of
the database like
i. Check constrain
ii. Primary key constrain
iii.Forign key constrain(Referential integrity constain)
iv. Unique contrain
v. Not Null constratins must be tested for the given
LEKAGE:When large volumes of data is inserted in to database
database cannot retain the data in the database.
this condition is called as database lekage.

In QTP we use data driven feature for storing large amount
of data i to database.



Is This Answer Correct ?    6 Yes 0 No

How to test the database manual? how to test data base lekage by using manual and also using QTP ?..

Answer / ramprasad.s


connect to the database by

username/password @ database name
then check for
Insert/update/delete/retrieve from the database.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Written Paper at Net Solutions: 1) Difference between Smoke Testing and Sanity Testing. 2) Bug life cycle. 3) Write the steps followed in STLC in your company. 4) Define: 1) BVA (Boundary Value Analysis) 2) ECP (Equivalence Class Partitioning) 5) Write test cases for a login screen with following fields/buttons: Username: Password: Login (Button) Cancel (Button)

2 Answers   Net Solution,

what are the defferent defect statuses?

4 Answers   AppLabs,

Smoke testing done by whom

7 Answers   TCS,


2 Answers   Hewitt,

What is the Diff between Code Walkthrough & Code Review? What is the diff between walkthrough and inspection? What is meant by GUI Testing?

0 Answers   HCL,

Hi,To all .Am Working as a Manual Software Tester in a software company.My Contract Period will be going to complete of this month.How can i fing any openings in chennai?and should s/w companies give preference to manual tester?suggest me .Advance happy new year to allllllll

2 Answers  

What is primary duty of tester ?

17 Answers   nvidia, Symantec, Veritas,

If client is not given any requirements then how will you test the application

3 Answers   AAA,

If there is non reproducible bug which developer is not ready to agree, how you will convince him.

3 Answers   HCL,

write a use case format for login

1 Answers  

Should every business test its software the same way?

1 Answers  

To Review the test cases , to whom u'll send the document?

4 Answers