How to test the database manual? how to test data base
lekage by using manual and also using QTP ?
Answer Posted / 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 |
Post New Answer View All Answers
Can any one give a summary of testing a territory management system? what would be the test scenarios, few test cases. how it works.
If there is non reproducible bug which developer is not ready to agree, how you will convince him.
write testcases for open dialogbox
Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u
Hi to all, im vaibhav i joined a MNC as a tester and i got a banking (HSBC) project can any one tell me as a fresher what kind of strategy i sholud use to perform better. thanx
On login window for username and password auto populated field means what !
You want a automation tool to be used for your project. How will you convince the client for the same. Please give me specific answer.
1.What types of documents would you need for QA, QC, and Testing?
What is a bug triage?
Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
After insert the record in front-end, how will you check the back end by manually? Please explain?
What are the cases why parameterization is necessary when load testing the Web server and the database server?
Can anyone tell me, What is wound fixing?
diff b/w desktop based testing & web application testing