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

What's an 'inspection'?

4 Answers   IBM,


Suppose,u have written 10 test cases for an application,but ur developer is not satisfied wht u wrote,then how will u justify him that ur test cases are correct?

2 Answers   CFC,


1. WHAT IS USE CASE? WRITE AN EXAMPLE OF USE CASE? 2. WHAT ARE THE PROPERTIES OF DEFECT TEMPLATE? 3. WHAT ARE THE TYPES OF TESTING? 4. WHAT IS TESTING? 5. WRITE TEST CASES FOR YAHOO MESSENGER LOGIN? 6. EXPLAIN PROBLEMS IN COMMUNICATIONS WITH CLIENT? 7. WHAT IS WEB TESTING? 8. WHAT SHOULD A SUCCESSFUL TEST ENGINEER DO? 9. WHAT IS BI DIRECTIONAL TRACEABILITY MATRIX? 10. TELL ME A REAL ACENARIO WHICH YOU EVER FACED? 11. GREAT BUG YOU FOUND IN YOUR CAREER?

1 Answers   ADP, Wipro,


if i provide u screens no documentation then how you will test that application without documentation .write testcases for that screens?

1 Answers   Genisys,


Please answer it:Your achivements as an manual tester? Dont answer :Ive found bugs? Bcoz it is your job.

0 Answers   JPMorgan Chase,


What is Traceability matrix?

7 Answers   Covansys, Wells Fargo,


how to write the test case for online (credit/debit) payment

2 Answers   Bank of the West, BirlaSoft,


what is CMMI and CMM standards and what r software Quality certifications.please explain me clearly

3 Answers  


What r the Macros?

1 Answers  


who will assign severity & priority

8 Answers   IBM, Value Momentum,


What metrics will be collected during the Testing i.e from requirement Phase to Maintainance Phase

1 Answers  


is there any checklist to check SRS document

1 Answers  


Categories