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
Hi....Friends....If anybody having Sample CSTP question papers, pls send it to the following Id... Thanks n advance... theramkumar@gmail.com
wat is test management ?what are the components available in test management?
Hi.....wat r d major bugs we can find in banking domain???
what will be verification and validation test cases for yahoo login page (only functional test cases)? Please explain in details.
What is the difference between GUI Testing,UI testing and Usability TEsting
What are all the netwoking tools, hardware tools and software tools required for testing a web-based n client server applicatopn?
How can you use technology to solve problem?
What makes a good software qa engineer?
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
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
What r the sequences that leads to automation?
What are the differences between web applications and client and server applications?
MS Paint
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
What is Stability and Performance Testing in Testing the TV