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.



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

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

More Manual Testing Interview Questions

1.how you know all test cases are cover in one application? 2.what is difference between error message and warning message ? 3.what are the items comes under traceabily materix?

7 Answers   iSoft,


Can you tell me the difference between functional and non functional testing?

1 Answers  


Tell the procedure to close word file?

4 Answers  


How do test documents in a project span across the software development lifecycle?

0 Answers  


The scenario is "while reviewing requirement docs(SRS)if u find or feel any requirement is not meeting the client's requirements" whom do you report?and what is your action?

7 Answers  


what are the contents of black box & white box testing.

3 Answers  


Explain about 'Performance testing' in Web based Application?

1 Answers   Crea,


What are the limitations for testing?

4 Answers   Thatavarti Technologies,


WHAT R THE TYPES OF TESTING U KNOW AND U EXPERIENCED?

5 Answers   Infosys,


Hi, Please answer this qns. "What is the test strategy and list of design characteristics for a login screen?" thank u

1 Answers  


What are the fields of Tracebility Matrix?

3 Answers  


Explain Agile testing with example?

4 Answers  


Categories