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

WHAT IS PROTOCAL TESTING..EXPLAIN? L2, L3 PROTOCALS TESTING MEANS WHAT?EXPLAIN BRIEFLY

6514


Explain unit testing, integration tests, system testing and acceptance testing?

993


Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.

4657


how to clarify functional requirements and non functional requirements in a srs?

1805


What is the difference between load testing and performace testing?

880


There is only requirements document. You have 10 days and 8 resources to release the system.At the end of the 8th day u tell ur TL that system is ready for release. How will you proceed with the testing process or in other words what all approach you will follow once you get requirements

1802


Hi, Please can one tell me how to test the usability testing, which method has to be used, how to write the report? Thanks Deepa

1815


If date field is a text field write test cases to validate it?

2213


What is test management?

1621


What are all the scenario for 1.google analytics 2.api 3.paypal

1659


What's the relationship between environment reality and test phases?

1170


What is coverage and what are the different types of coverage techniques?

874


what are all the things we will include in " what to be tested and what not to be tested" in Test Plan

1846


What is junit & api?

1893


What is a test scenario?

903