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
About Hierarchy level in your company.
Hi, Can anyone suggest a test case writing technique for the below scenario. 1. User draws a lines on the image 2. User selects the lines and right clicks ( Measuremnts like distance between the start and the end point, coordinates of start point and coordinates of end point) 3. User selects one of the measurement Measurement is displayed Just want to highlight, i am looking for a test case writing technique for above scenario.
What is a failure?
Password is having 6 digit alphanumeric then what are the possible input conditions?
How does your preferred work style work with the ideal test-manager role that you just described? What is different between the way you work and the role you described?
What is the Diff between Code Walkthrough & Code Review? What is the diff between walkthrough and inspection? What is meant by GUI Testing?
Beyond the customary advantages of having a testing group, what are the benefits does a company receive from a well run, automated testing group?
Test Cases For Router&Switch
What does you mean by positive and negative testing & what is the difference between them. Can anyone explain with an example?
how mapp the defect id in quality center?
how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??
How can you define state tanstion testing aswell decesion testing with examples.how you can differ them too??
What is XML Testing? Do we have any tools to test the XML? Please let me know.
Negative test cases for phone camera
What is stub?