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


Please Help Members By Posting Answers For Below Questions

What are the phases involved in software testing life cycle?

667


what is meant by application server and its functions?

6139


can anyone tell me few critical bugs in ecommerce project.

5572


What is sanity?

621


What are testing techniques? What is difference between general and specific?

1557






I have 2+ year of work exp in manual testing and i have good knowledge in QTP.anybody have requirement in your company please please tell me

1454


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.

1979


Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks

1789


What do you do if the bug that you found is not accepted by the developer and he is saying its not reproducible.

707


Pls u can u r mail id to my personal mail id also if they dont want to give u r mail id n comman place

1525


How do you get programmers to build testability support into their code?

2228


Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

1631


write test case for gmail sign up page ?

1568


date format and we should 8 digits - not accepted only /accepted write how many in test cases in the date format valid , and in valid

1037


What are the advantages of black box testing?

659