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

If asked to create a Configuration Design Pattern, where would you start?

1701


whats the reason to display the password(not in encrypted form) in the script in load runner but not in QTP?

1899


can any one post the format of tracebility martrix Plz...... Maid Id: sandhya.shyamala@yahoo.com

2219


What kind of testing to be done in client server application and web application? Explain

1169


Hi Friends, Can anubody give me brief overview of Automation tools.. (basics of tools-summary)of following tools? 1.Qualty Center 2.Load Runner 3.Win Runner 4.Q.T.P mail me on ...rachna.huda@gmail.com

2173


What is manual testing and what is it process?

1569


1.Tell me negative test cases for notepad 2.Tell me the factors for for writing severity based test cases

6299


hi sir, i completed my GNIIT from NIIT. i recently joined in IT company for Testing(manual) on JD EDWARDS.So,i wanna to ask that after taking 1yr experience can i able to do Testing .NET in another company.Pl i am confused pl send yours suggestion throw my email(paresh_shindeal@yahoo.com)

1995


what is the most critical bug u have to find in ur project.My application is ERP based,in this purchase module is there.plz tell me the answer?

2726


diff b/w desktop based testing & web application testing

2019


How will you do beta testing?

1022


How to test a Falsh player scrollings?

2244


integration test cases for mouse and keyboard

3701


What is the most important phase in STLC and Why

1584


What is Application Performance testing and Operational performance testing

2032