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

Can you explain calibration?

1139


how will we change the server system time?

2300


How can software qa processes be implemented without stifling productivity?

1162


define risk management system with example ?

1950


Difference between smoke and sanity testing

1869


What is bottom-up approach?

1089


Which criteria should take in account while doing CMS testing of any project?

1749


What are the Major Functionality for a ATM machine ??

5987


Test Cases For Router&Switch

2619


How to write test cases for nevigating menus? Ex. Course -Topics -Subtopics

2196


What are quality assurance and quality control?

1188


What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?

2947


1) Test summary contains ? 2) Requirement Tracebility means ? 3) Test Effort contains ? 4) Test Planning Productivity ? 5) Metrics should be caluclated ? 6) Interest rate Rsik is a type ? 7) Test analysis and Design process task? 8) secured loan is a part of Liability (or) assest in a balance sheet? 9) Money Market means? 10) a ------ specifies all of the terms of a loan and the obligations borrower ? 11) what is a primary market is ? 12) Quality of Testing measure with ? 13) Company has a share with facevalue 10 rs/- and NAV of 37 after comapny has given Dividend of 35 % then How much NAV become ? ( I don't know what is NAV means, question overall Idea I am giving not 100% perfect ) the potions for these are 1) 33 2) 33.50 3) 37 4) 42 14) one compay has taken 10 million loan from a bank for a Interest rate is 10 % and base amount is 0.4% so how much they had paid monthly Emi ? they provideansews like 1) 100000 2) 114000 3) 140000 4) 104000 Remaing questions I not remember.

2731


How can write testcases on a code under development pls give asnwer

2029


Diffrence b/w functional testing,functionality testing,system testing?

2089