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...

  1. Categories >> Software >> Testing >> Manual Testing
  2. Suggest New Category

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.

Question Posted / guest


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

Test Case Design Techniques like BVA, Equalance partitioning, Error guessing?

2 Answers  

what is suspension criteria and exit criterai in test plan/????

3 Answers   Cap Gemini,

What is Software Testing ? Why software testing is necessary ? When to stop testing?

1 Answers  

any one plz send me test cases on fan,pen,glass,cell phone,mouse and printingpage

1 Answers   SQS,

explain sdlc?

2 Answers   SAP Labs, STC, TCS, Thirdware,

example for bug not reproducible

6 Answers  

How will we come to know that its a bug,in what situations we consider it as a bug?

3 Answers  

How can you find dead code!!

3 Answers   Satyam,

when testing will starts in a project?

12 Answers   Ordain Solutions,

write a test case for air conditioner

6 Answers   Wipro,

What is Picoscore? It is related to Banking Project? Plz let me know if any body knows this

1 Answers   Mindlance,

What about the test case if the field only takes a certain number of characters or a minimum number?

0 Answers  

For more Manual Testing Interview Questions Click Here
Categories