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 are the bugs we cannot find in black box?

1208


What makes a good software qa engineer?

1155


What is desk checking and control flow analysis

1331


What is the difference between Functional testing and Unit Functionality testing?

2079


what we have to read to gain knowledge in banking and financial domain(software testing) for 4+ experience

2231


Can you explain the elementary process?

1165


What will be your approach if a particular script in Load Test fails?

2289


anybody there with 3+ exp in software testing looking for change and like to work in bangalore fwd your resume to vinodhanandhan@gmail.com

2273


What is an exit criteria?

1148


What is revision history and the content of revision history table?

2007


what is Test management fundamental?

2275


Write 10 test scenarios to test remember me checkbox present in login window

1593


Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.

2854


What do you do (with the project staff) when the schedule fails?

2103


what is the test plan of facebook?

3033