|
|
|
Software Central: S/W Testing | | testing tools | |
| Boss, Me Last Name TP Lo Teeseyocchu Kada :)
Posted by: Mr. Raj Raj At: 12, Jul 2006 8:53:02 PM IST
Hi Friends...
Somany friends asked me about
What is Database testing.
How we test that.
What is Data migration testing.
What we are trying to test in that.
Now iwill tell about
How to test stored procedure or stored procedure testing
Test coverage criterion: each and every stored procedure must be tested at least once
• Individual procedure tests
• Verify the following things and compare them with design specification
• Whether a stored procedure is installed in a database
• Stored procedure name
• Parameter names, Parameter types and the number of parameters
Outputs:
• When output is zero (zero row affected)
• When some records are extracted
• Output contains many records
• What stored procedureis supposed to do
• What a stored procedure not supposed to do
• Write simple quaries to see if a stored procedure populates right data
Parameters:
• Check parameters if they are required
• Call stored procedures with valid data
• Call procedures with boundary data
• Make each parameter invalid a time and run a procedure
Return Values
• Whether a stored procedure returns values
• When a failure occurs, nonzero must be returned
Error messages:
• Make stored procedure fail and cause every error message to occur at least once
• Find out any exception that doesn’t have a predefined error message
Others:
• Whether a stored procedure grants correct access privilege to a group/user
• See if a stored procedure hits any trigger error ,index error and rule error
• Look into a procedure code and make sure major branches are test covered
Integration tests of procedure:
• Group related stored procedures together. Call them in particular order
• If there are many sequences to call a group of procedures, Find out equivalent classes and run tests to cover every class
• Make invalid calling sequence and run a group of stored procedures.
• Design several test sequences in which end users are likely to do business and do stress tests.
If you have any queries then mail me. I will try to answer regarding database testing. In any domain.
All the best
Posted by: Mr. SATISH GORRIPOTU At: 10, Jul 2006 9:42:46 PM IST
hi,
please clarify the difference between TestResponsibilityMatrix and Requirement TracebilityMatrix please send answers to
krakesh_77@yahoo.co.in
Regards
Rakesh
Posted by: Mr. rakesh karanam At: 31, May 2006 3:11:00 PM IST
hai guys iam very delighted after logging in this site
how are u
i need a help from u
i need projects(testing tools) to put in my resume
if u have any please send me
i am very thankful if u do help me in this matter
i need urgently 2 projects(insurance,banking)
ok guys
all the best
this is my mail ID
ramachandra_reddy_p@yahoo.com
Posted by: Mr. ramachandra reddy padala At: 22, Mar 2005 9:26:43 PM IST
hai guys iam very delighted after logging in this site
how are u
i need a help from u
i need projects(testing tools) to put in my resume
if u have any please send me
i am very thankful if u do help me in this matter
i need urgently 2 projects(insurance,banking)
ok guys
all the best
Posted by: Mr. ramachandra reddy padala At: 22, Mar 2005 9:23:38 PM IST
| |
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
