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

how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?

6087


how to create automation frame work ?

1584


How to test an application if it was already developed and it is in the state of changing the functionality according to the customer requirement How to start testing in this situation. I got an application to test.It is a desktop application.It is still developing and started 8 months back.how can i start to test this application? Is it the right way to test it in "Random testing"? or writing the testcases from page one and executing them.i have an another responsibility that is I have to automate that application. can anyone tell me what is the process to test this application.

1546


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

1521


Discuss what test metrics you feel are important to publish an organization?

4121






explain fish model in detail?

1727


What are the disadvantages of manual testing?

647


Upps..., sorry my email id is this : preet405p@yahoo.com Thanks in advanced.

1649


Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.

7090


What is rapid application development model (rad)?

719


What is agile testing and why is it important?

674


What is defect removable efficiency?

684


What is mutation testing & when can it be done?

672


What is sanity?

623


need testing projects where can i find them

1664