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

How do we find pass and fail percentage of Test cases. Anybody can give answer to me. Thanks in advance

2 Answers   HCL, Satyam,


Where will you give the Reproduce option in Bug report?

2 Answers   GE,


One or more text elements or even all text elements in a page should be markable as required to match. -What are the categories of content validation is described in the text above?

1 Answers  


what are the ways to crash an application when it is unter testing?

3 Answers   Keane India Ltd,


How do you manage your writen/modified/executed test cases, Bug report etc,without using any tool?

1 Answers  






Hi Everybody ,how can i explain the testing projects in the interview point of time? Please let me know .if it is insurance project, what procedures can i follow ?

1 Answers  


When do you escalate issues to your Manager?

1 Answers   MTN,


From which document we will get Technical Requirements ?

4 Answers   IBM,


who do sanity testing ? who do smoke testing ? plz give me correct answers.

11 Answers   Accenture, Danlaw,


Explain a bug which if you have missed could have created a big problem?

1 Answers   Crea,


What is Independent Testing?

0 Answers   Satyam,


What is the difference between Test Cases and Test Scenarios

3 Answers  


Categories