Database testing
What is way of writing testcases for database testing ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Arjun PanwarPosted Jan 2, 2012, 3:49 PM
Sean StewartPosted Dec 28, 2011, 11:37 PM
Arjun PanwarPosted Dec 1, 2011, 7:17 AM
Satyapriya NayakPosted Nov 29, 2011, 5:41 AM
In database testing we need to check for,
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures
5. The field size defined in the application is matching with that in the db.
You have to do the following for writing the database test cases.
1. First of all you have to understand the functional requirement of the application thoroughly.
2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), triggers used (if any), stored procedures used (if any), input parameter used and output parameters used for developing that requirement.
3. After knowing all these things you have to write the test case with different input values for checking all the paths of SP.
Thanks