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 Catapult Testing in E-Learning Domain?

0 Answers   Raytheon,


What is Benchmark Testing

4 Answers  


who preapares use case document? who preapares use functional point document? who preapares use test sceanario document?

1 Answers   Accenture,


hi this is divya. i have 2+ yrs exp in manual testing. I worked at bangalore. Now i shifted to chennai. If any openings for manual testing please call me 9245392708.thanks

3 Answers  


Can you please provide me the standard testcase review templete and Test plan templete.In my company we are not following any Standards templete so.Please guve me some Excell attachments.

0 Answers   HP,


What are the common defects revealed in Functionality testing?

2 Answers   AppLabs,


Hi All, What is meant by compliance project?

1 Answers  


what is the difference between stress and load testing

6 Answers  


If you open a bug in build -1 and that get closed in build-2 . Again the same bug a raised in build -3. Then what state will you give to that?

6 Answers   TCS,


Hi, can any tell how a tester can be judged? i have to interview a tester, how should i judge whether he has a justified experience or not? how a person with 3 years of experience in manual testing can be judge?

0 Answers  


How Requirement is linked with traceability matrix. Give proper example

1 Answers  


What is Desktop Testing

0 Answers  


Categories