Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what s test block ratio? please any one answer me..

2351


what is the difference between PEGA based web application testing versus web application testing?

5326


write the test case for Bulb & Mobile phone

8927


what are the risk factors in the project? what is the base for testplan and entry criteria ,exit criteria for test plan?

2505


Hello Varun, Kindly send me the material as well as sample question papers as i am interested in doing the certification. Kindly help me out in this regard. Here is my mail ID: bjyothitesting@gmail.com

2297


Which is the best book to ref. for design the test cases/scenario in manual testing,which gives detailed idea with all the strategies ?

7000


How do u prepare test environment for ur application?

2199


What is validation in software testing?

1256


What are the advantages of waterfall model?

1158


What are the different strategies for rollout to end users?

1341


what are your thoughts on SPRINT duration

2184


What impact ratings have you used in your projects?

1163


Enlist some bug status along with its description?

1246


What is state transition?

1337


Explain thread testing.

1119