What is way of writing testcases for database testing?



What is way of writing testcases for database testing? ..

Answer / ramyab.mca@gmail.com

Hai...

You have to do the following for writing the database
testcases.

1. First of all you have to understand the functional
requirement of the application throughly.

2. Then you have to find out the back end tables used,
joined used between the tables, cursors used (if any),
tiggers used(if any), stored procedures used (if any),
input parmeter used and output parameters used for
developing that requirement.

3. After knowing all these things you have to write the
testcase with different input values for checking all the
paths of SP.

4.You have to know the names of the tables and the column
names where data is getting updated for specific
funcionalities

5.You have to know the parent as well as the child tables
associated with them

One thing writing testcases for backend testing not like
functinal testing. You have to use white box testing
techniques.


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





Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Do the test cases differ for Functional,Integration,System and User Acceptance Testing???

2 Answers   iFlex,


what is prototype testing, component testing, thread testing

1 Answers  


SAY I HAVE A GMAIL PAGE OPENED IN IE 8 NOW WHAT WOULD BE YOUR COMPATABILITY TEST CASES FOR THAT>?

1 Answers   RBS, Wells Fargo,


Tell me abuot your daily activities as a test engineer.

6 Answers   InterSoft,


Can any one Explain what is Impact Analysis?

3 Answers   IBM,






what is CMMI and CMM standards and what r software Quality certifications.please explain me clearly

3 Answers  


why u need peer review doc ?

3 Answers  


what are the duties of Quality Assurance engineer and QA Tester?plzzz answer as soon as possible thanku

3 Answers  


Describe any bug you remember. Plz Give some real examples

0 Answers   TCS,


7.Do you have working knowledge on any international quality systems?If yes name then?

1 Answers   VJIL Consulting,


whatis ur company testing process?

2 Answers  


what is incremental model?

3 Answers  


Categories