What is Database Testing? How will you do it?

Answer Posted / ajit kumar lal

Database testing means any/all of following as per the
application:

1. Ensuring the Data validity: requires SQL queries to
validate the same
2. Ensuring the Data integrity: requires various
constraints (both IO and Buisiness) to check
3. Ensuring the performance of database operations
especially in case if accessing Views and Indexes: Various
tools are available to check the same especially Database
Refactoring. You can also your Database sandbox on the fly
and use TFD or TDD approach to test the same
4. Ensuring the performance of Database when using
Functions, Cursors, trigers etc.

I hope above is clear to all of you......

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the dimensions of the risk in qa?

795


What do you understand by ‘test effectiveness’ and ‘test efficiency’?

779


What is process area in cmmi?

802


What is a test strategy and what does it include?

790


Please, anyone out there that had been a SQA Tester, would You all give me a hint on this Job? Is becoming a SQA Tester is easy? Is it a tough one? Please help me on finding a way on this very first Job of mine?

1841


Q. How do you select product components for validation?What are the contents of QMS?

1721


What is boundary testing?

827


Is automating some test case is important? What about the maintenance? When will automated test become uneffective?

1697


What is destructive testing?

916


Case Study:-Given a standard calculator with the basic functionality of addition,substration,multiplication and division-write the test case to test this and tell how did it take to write the above test case and how ling would it take to execute them?

1866


What should QA require of Development?

3923


How is monkey testing different from adhoc testing?

788


Describe the benefits of agile testing.

811


What is basis set?

764


-What do you think about unit testing? -How do you assure quality of the code you release? -How do you release software?

1945