What is way of writing testcases for database testing?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

If automating - what is your process for determining what to automate and in what order

1545


What is Wound Fixing?

1905


How do you Prepare a Defect Managemnt Policy

1645


What is concurrent user hits in load testing?

844


What and why is api testing?

965






what kind of testing have u done?

1528


3.if a questions asked as,what is the quality standards you are following? what i need to tell.

1377


How to test a Falsh player scrollings?

1781


what is the cheklist to check SRS document (after releasing) as a test ingineer and how can we check

1601


what are questions asked in TCS for database tester (sqlserver)?ay idea

2481


9.Data – driver automation typically includes?

2930


If anybody from banglore having the real time exp in manual testing with 3+ yrs exp and looking for change send your profile to vinodhanandhan@gmail.com

1517


What are testing techniques? What is difference between general and specific?

1653


What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)

1676


Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1635