what is data base testing, explain with example

Answer Posted / ramyab.mca@gmail.com

Hai...

Testing the backend db like comparing the actual results
with expected results.

DB testing basically include the following
1)Data Validity testing
2)Data Integrity testing
3)Performance related to database.
4)Testing of procedure, truggers and functions.

For doing Data validity testing you should be good in
SQL queries, for data intigrity testing u should know abt
reerential integrity and different constraint.
For performance related things u should have idea abt the
table structure and design.
For testing procedure triggers and functions u should be
able to understand the same.

K,Byeee..
Thanks & Regards
B.Ramyasri.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If anyone have attended interview with deloitte for the post of senior manual test engineer. Please share the interview process and the questions asked. How to prepare for the interview. Thanks in advance

4480


What is AGP?what is setup.inf?What are the ways to install driver?

1883


In Manual testing how to test proxy servers? can u please explain with example?

1673


1.What is configuration Management? 2. Explain Impact Analysis 3. Explain Peer Review 4. what i kickoff phase of Formal Review. 5. Whatv are the phases of fundamental test process. 6. what is state transition testing. 7. what is LCSAJ 8. Test conditions are derived from where?

1633


what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???

1686






Hi Friends, This is Chennamsubbaraidu.i Have 2+ Years Realtime Exp in Manual Testing.Am Looking to Shift From My Present Company.Please if u Have Any Openings in Your Company's, Please Let Me Know.Any Location Prefer.Thanks.

1507


Tell me some Adhoc testing scenarios of ebay (online auction product)?

3508


how will you test transfer funds module...explain in detail

1248


how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??

1232


When to stop testing? (Or) how do you decide when you have tested enough?

735


How does your preferred work style work with the ideal test-manager role that you just described? What is different between the way you work and the role you described?

1794


How did you do unit testing in your project?

796


what are the types of Bug?

1139


I am DD. I am working as a Tester in e-learning company? IS there scope for content testing? or i have to change to software testing. pls guide me...

1771


What is the difference between Functional testing and Unit Functionality testing?

1625