Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is way of writing testcases for database testing?

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

Answer /


You have to do the following for writing the database

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

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

Thanks & Regards

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Which is not formally included in Test Plan? 1)Features to be tested 2)Incident reports 3)Risks 4) Schedule Pls reply .Thanks

9 Answers   HCL,

What would u do if u come across a it.....but the programmer is in a diff location ( say u in India n he is USA)..and he keeps accepting its a bug?

3 Answers   AZTEC,

There are so many big companies like Reliance, Satyam, Infosys etc...But, y do u want to work for our company only?

7 Answers   RR Donnelley, Tanla Solutions,

what is 4 p's? Exact difference between testing and QA

7 Answers   Patni,

On Registration Form, if some fields are not mandatory to fill then those fields can accept any invalid input. OR there may have some validation. E.g. Email id field - Not mandatory to fill. If user enter Email id = 453454 should it accept?

1 Answers  

Why does Software have bugs? urgent pls .....

5 Answers  

What is latent bug? the people who is know about this plz kindly give the ans.

1 Answers  

3. Name three words or characteristics that describe this Web site.

0 Answers  

what is the importance of test data while testing the application? and how hard it is to set up the test data?

2 Answers  

When u will start writing test cases?who will intemate u ,to write test cases?if the requirements changes day by day what will u do allready written test cases?

2 Answers   CSC,

What is testing process

8 Answers   IBM,

How will you test Email field?

5 Answers   IMC, Newgen,