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.



How to write test cases for testing databases,especially for testing and writing test cases for st..

Answer / 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

More Manual Testing Interview Questions

Can any one explain about state based and graph based testing? and the difference between them? Very urgent.......... Please...... Thanks in Advance......... regards, Murthy.M

1 Answers   Oracle,


How many testcases have you written till, now as an average per project?

1 Answers   AppLabs,


What exactly is quality control? Is it similar to quality assurance?

0 Answers  


What is the difference between White Box testing and Unit Testing?

9 Answers   Accenture, Salus,


What is alpha testing?

0 Answers  


When you will raise defect? before defect raising what you will do?

2 Answers   Cap Gemini,


Who will prepare FRS(functional requirement documents)? What is the importent of FRS?

2 Answers   Infosys,


what is the difference between Risk based and Requirement based testing???

0 Answers  


from where do u collect test data if u miss some data what will happen

0 Answers   Infosys,


What is the Waterfall Development Method and do you agree with all the steps?

1 Answers  


What's the role of documentation in QA?

1 Answers   Crea,


What is your framework of current project

3 Answers   Cap Gemini,


Categories