How to write test cases for testing databases,especially
for testing and writing test cases for stored procedures.



How to write test cases for testing databases,especially for testing and writing test cases for st..

Answer / guest

Hai...

We can do database testing in three ways(appraoch)
1.From front end GUI
2.Purely on back end
3.Using both front end and back end

In the case of database testing frm front end,
It is very easy no need of SQL querying skills,
directly we will enter the data in to database and again
we will call them from front end.

Here the data which is entered into front end GUI should
store properly in the back.

if in the case there is no GUI for that software,no way we
have go for pure back end database testing.

To conduct database testing one must know SQL knowledge
to write query for data insertion,updation,deletion...like
DML,DDL,DCL commands , Stored procedures,views knowledge
to test databse.
Third one is more reliable hybrid and time taking process.

Writing of tescases varies depending on the approach of
database testing.

to write test cases on database input is
databse structure tables,
constraints,
relation betwee the tables we need.

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

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Tell the test cases to test Login Password screen?

7 Answers   CybAge,


how do u do integration testing supose u ar in hotmail login page 2nd is mailing page how do u do integration testing for this kind

4 Answers   Sapient,


1.what is test scenario? if possible give me some documents? 2.what's the difference between test scenario and frs?

3 Answers  


What is a 'walkthrough'?

2 Answers   IBM,


HOW TO CREATE SRS REVIEW REPORT TO PL?

0 Answers  






how do u find out memory leaks in any application..?

2 Answers  


What's the exact meaning of quality

20 Answers   AppLabs, QCA, Textiles,


It will be a great help if any one will help on this issue, Three test cases got faied [TC#1, 2 and 3] and all are there in the same TestScript. For all the three failed testcases a bug is logged refrencing to the three failed testcase. In Next round of validation out of three two TC#2 and 3 got PASSED and TC#1 FAILED. I am confusssed if in this scenario if i mark the PASSED test case as PASS OR FAIl, as the the Defect will have BOTH PASS and FAIl at the same time. Please clarify How to handel this scenario.

2 Answers   TCS,


explain sdlc?

2 Answers   SAP Labs, STC, TCS, Thirdware,


Explain the importance of agile testing?

0 Answers  


How and what to functionally test in a web based application manually?

3 Answers  


How to write Test cases for pen in tabular form including all phase of test case like Test id, Test Objective, Prerequisite etc.

1 Answers  


Categories