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.
- 1 Answers
- 5718 Views
- IBM, I also Faced
- E-Mail Answers
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
Can you explain an application boundary?
What are the main key components in web applications and client and server applications? And explain the differences between them?
What is the difference between white box, black box, and gray box testing?
What are the main key components in web applications and client and server applications?
What is Independant Testing? When and where this type of testing will be performed?
What is a failure?
What is difference between Manual testing and Pega/BPM testing?
i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??
What is the procedure of manual testing?
What are joins and subjoins in the data bases what is data driven testing what is verification and validation What is Quality Assurance (QA) and Quality Control (QC) Is Verification is related to QA and Validation is related to QC ? which type of model you follow basically in your project what is a use case How to test a Bike how to test a Lift (Elevator). which configuration Management tool do you use which Bug tracking tool do you use explain Bug life cycle what is Regression testing what is ALPHA testing ans BETA testing What types of testings comes under Non functional testing what is TEST DIRECTOR what is CMM and CMM i whar are Expressions in Winrunner What is a Compile module Is it Necessary to open the tool first or the application first after getting a bug what will you do if you add a new object or a new module for the existing application then how will you test the application which Defect tracking tool do you use what is change management What is smoke Testing what is sanity testing A application is given to you but the requirements and functionalities are missing what will you do to start the testing which testing documents will be received by the client
In manual testing, what are stubs and drivers?
1. Give me an example of something you tried at work but did not work out so you had to go at things another way. can somebody give a real time example
What are differences in testing a client server and a web application?
Can you explain process areas in cmmi?
Why do we need different environments and different data? What is the other name for environment? Justify your explanation ? real time experts pls xplain?
