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

what is defect density?

2 Answers  


What is error guessing and error seeding?

1 Answers  


what is port testing and do it comes in manual testing?

0 Answers   Covansys,


what is difference between regression & retesting?

7 Answers  


what are the different types of defects that can be found out in real time?How can we recognize what are the features to be tested and not to be tested in a system test plan?

2 Answers   Keane India Ltd,






what is smoke testing? what is sanity testing?

5 Answers  


Tell the procedure to close word file?

4 Answers  


what is test case scenario?

3 Answers   MAQ, MAQ Software,


What are the main key components in web applications and client and server applications?

0 Answers  


What is smoke testing and what is sanity?

0 Answers  


How do you conclude which section is most risky in your application?

1 Answers  


Please explain how to elaborate on the types of system/functionality for testing Payments, Statements, & Transactions features in a bank.....like what do we test in these,in detail? It's urgent, please reply...thanks in advance.

0 Answers   IBM,


Categories