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
database.

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
database.
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.

Byee

rajendra
rajendra_penumalli@yahoo.com
9885162742

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

Hi

connect to the database by

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


sun_ramprasad@yahoo.com

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Is it Mandatory to use "ECP" & "BVA" Techniques for "LOGIN" Page???,Can any one tell me the correct answer ?,If Yes then why?

1 Answers  


What is Test Procedure? What are Test matrices? What is Tracibility matrix?

4 Answers   ABC,


Write test scenario of calendar.

3 Answers   Citi Bank,


what is ECP?

4 Answers  


how to test manually from date and todate selection from calender

3 Answers  






whatis ur company testing process?

2 Answers  


what are the add-ins needed to test .net and c# projects?

1 Answers  


What are teh characters of a good tester

6 Answers   Microsoft,


How do you decide when you have 'tested enough?'

10 Answers  


What is your testing approach/plan if requirements are frequently changing?

2 Answers  


would we do functional testing inside integration testing

3 Answers   iGate, iQuest,


Entry and Exit Ceiteria for System Testing?

2 Answers   Patni,


Categories