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

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


Please Help Members By Posting Answers For Below Questions

Hi....Friends....If anybody having Sample CSTP question papers, pls send it to the following Id... Thanks n advance... theramkumar@gmail.com

2611


wat is test management ?what are the components available in test management?

1597


Hi.....wat r d major bugs we can find in banking domain???

1984


what will be verification and validation test cases for yahoo login page (only functional test cases)? Please explain in details.

13635


What is the difference between GUI Testing,UI testing and Usability TEsting

1947






What are all the netwoking tools, hardware tools and software tools required for testing a web-based n client server applicatopn?

1456


How can you use technology to solve problem?

1598


What makes a good software qa engineer?

645


what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important

1483


HI. ANYONE HAS ATTENDED INTERVIEW FOR TESTING IN MINDKRAFT GLOBAL. I HAVE WRITTEN TEST FOR SOFTWARE TESTING. CAN ANYONE TELL ME WHAT ALL QUESTIONS CANBE ASKED. PLS REPLY. THANK YOU

2141


What r the sequences that leads to automation?

1502


What are the differences between web applications and client and server applications?

682


MS Paint

1643


Hi Friends, I wish to start my career in manual Testing as I believe I am ready to face Interviews.I have good domain knowledge in banking(investment and retail) and insurance.To be in the competition I have added three years of testing experience to my CV apart from my domain experience. Can someone please advice some real time tips which can help in facing the interview. Thanks in advance

1631


What is Stability and Performance Testing in Testing the TV

1869