how to write test cases for testing databases,especially
for testing and writing test cases for stored
procedures.any real time database testers.please answer me.
Answer Posted / rajendra
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.
ok friends byeeeee
rajendra
rajendra_penumalli@yahoo.com
hyderbad
+91-9885162742
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the bugs we cannot find in black box?
What makes a good software qa engineer?
What is desk checking and control flow analysis
What is the difference between Functional testing and Unit Functionality testing?
what we have to read to gain knowledge in banking and financial domain(software testing) for 4+ experience
Can you explain the elementary process?
What will be your approach if a particular script in Load Test fails?
anybody there with 3+ exp in software testing looking for change and like to work in bangalore fwd your resume to vinodhanandhan@gmail.com
What is an exit criteria?
What is revision history and the content of revision history table?
what is Test management fundamental?
Write 10 test scenarios to test remember me checkbox present in login window
Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.
What do you do (with the project staff) when the schedule fails?
what is the test plan of facebook?