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.

Answer Posted / guest

Hai...

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.

K,Byeee...
Thanks & Regards
B.Ramyasri

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

About Hierarchy level in your company.

2051


Hi, Can anyone suggest a test case writing technique for the below scenario. 1. User draws a lines on the image 2. User selects the lines and right clicks ( Measuremnts like distance between the start and the end point, coordinates of start point and coordinates of end point) 3. User selects one of the measurement Measurement is displayed Just want to highlight, i am looking for a test case writing technique for above scenario.

2045


What is a failure?

1242


Password is having 6 digit alphanumeric then what are the possible input conditions?

1177


How does your preferred work style work with the ideal test-manager role that you just described? What is different between the way you work and the role you described?

2160


What is the Diff between Code Walkthrough & Code Review? What is the diff between walkthrough and inspection? What is meant by GUI Testing?

2098


Beyond the customary advantages of having a testing group, what are the benefits does a company receive from a well run, automated testing group?

3411


Test Cases For Router&Switch

2611


What does you mean by positive and negative testing & what is the difference between them. Can anyone explain with an example?

1133


how mapp the defect id in quality center?

2224


how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??

1622


How can you define state tanstion testing aswell decesion testing with examples.how you can differ them too??

2395


What is XML Testing? Do we have any tools to test the XML? Please let me know.

2131


Negative test cases for phone camera

718


What is stub?

1220