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 is agile testing and why is it important?

693


What is an end-to-end testing?

629


What is the difference between action & script ?

1911


How will you do beta testing?

639


Is quality control similar to quality assurance?

643






is it possible web application make it as executable file

1895


Explain the procedure for manual testing.

716


How to do manual testing of a E-insurance project (end to end process)

2764


What is Stability and Performance Testing in Testing the TV

1877


Wat type of questions ll be asked in interview for an 1-2 yrs. experinced persond and i need some database concept question in testing.

1814


What is meant by Boundary value analisis and Equalence partitioning? Can give derive this using these methods? In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000

1593


What is 'Account Conditioning'?

3978


Describe any bug you remember. Plz Give some real examples

1641


write test case for gmail sign up page?

3238


where do we work with Application, web and Database servers Means which type of applications.

1469