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
How do you test a web application for dump and deaf??
If date field is a text field write test cases to validate it?
Is Anyone attended the manual testing interview with capgemini in recent past. please let me know the type of questions they can ask. Thanks
whar are the contents in db testing test case template
how will you test a wine filled bottle along with 100 glasses
In testing environment have you ever found any areas for improvement while you at work. (Please give some real life example).
can anyone tell me the scenarios for online banking transaction ?
When first time we are testing the screen then we have to write that this screen should contains so & so columns [ suppose there r 10 columns on that screen]in the expected result
what is quality Factor
i want to for technical interview question paper along with in tesrviwe Phases i need
Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance
user id @ yahoo.com (or) yahoo.co.in (or) gmail.com.... etc
What is the different between SIT and UIT?
what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?
How do test documents in a project span across the software development lifecycle?