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.
- 1 Answers
- 11512 Views
- I also Faced
- E-Mail Answers
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
Can any one say me how to do Performance testing step by step plz for a desktop application(offline application).all the data is stored in internal server itself can any plz help me. ts quite urgent friends.
Can anyone please suggest me a online book on manual testing??
What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?
what r the 5 major defects that u found in ur shopping related project?
Can anyone please answer the below question on Manual Testing: Tell me about atleast 5 bugs you come across in your last testing?
Different types of design diagrams that supports to write test cases ?
i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??
Which test cases are written first: white boxes or black boxes?
What were the major challenges u faced while testing
i want manual and automation test cases and interview questions
What is smoke testing and what is sanity?
what are all the things we will include in " what to be tested and what not to be tested" in Test Plan
Can any1 tell me suppose u r doing manual testing on unix platform with Shell Script, then how it is done? How u r implementing it & what is the use of Shell scripting on Manual Testing? plzzzzzzz i need ur help.
Give the real-time example for back-to-back testing?
hi all I have an overall experience of 12 years working in an EDP setup(worked in a manufacturing setup in a German MNC). On my request, I was relieved from my duties in Sep 06 for maternity reasons. However I would like to pursue a career in a software organization as a manual tester. I obtained my proficiency certificate in Software Testing from STAG SOFTWARE LIMITED 2 months ago i.e in May and would now like to continue working in this field. However I am unable to find a job until now. If anybody knows of a opening at bangalore, kindly let me know.
