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

As you are working with cmmi level 5 company ,can you tell me what processes you r following as QA engineer?

2023


There are some features to improve the performance of a Product. What are those factors?

1604


How to test an Scheduled event? For ex: in an investment banking application, the scheduler will create an equity anbd user has nothing to do but tester has to test if the instrument is created properly or not?

1699


I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC

1574


How will you set the Dependency in the Quality center? Say if you will fail a test case and two or more test cases are dependent on that particular test case. In this case how will you handle in failing the test case.

2227






What are the different test techniques used in functional testing?

663


How should your staff be managed? How about your overtime?

2753


Our software designers use UML for modeling applications. Based on their use cases, we would like to plan a test strategy. Do you agree with this approach or would this mean more effort for the testers.

1638


HI GUYS,, I HAVE 3 YEARS OF EXP IN MANUAL TESTING...NEXT MONTH ONWARDS I WORK FOR MOBILE TESTING....PLS SUGGEST ME WHAT I LEARN FOR TRAING,, MOBILE TESTING OR ANDROID....FOR MOBILE TESTERS NEED ANDROID(IFONE) DEVOLOPMENT KNOWLEDGE OR NOT? EXPLAIN CLEARLY

1689


What are some best practices that you should follow when writing test cases?

664


What is white box testing?

744


What is known as data-driven testing?

619


What is a test scenario?

695


What r all the security problems u r facing & the measures taken to solve.

1830


MS Paint

1637