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.
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 |
EXPLORATORY testing means?
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?
If anybody from banglore having the real time exp in manual testing with 3+ yrs exp and looking for change send your profile to vinodhanandhan@gmail.com
What is the Diff between Code Walkthrough & Code Review? What is the diff between walkthrough and inspection? What is meant by GUI Testing?
Who is the father of Software Testing? Who has invent the water fall model? Who has invent the spiral model? Who has invent the prototype model? Who has invent the v-v model? Who has invent the Hybrid model?
What is a Show Stopper?
When we enter valid user ID and passwords and unable to login then what do we test more
What is the most important phase in STLC and Why
1. What is Test data? 2. What is Test Development? 3. What is Boundary value & Equilance Partition? 4. What is Compatability testing? 5. How do you know Prepared Test cases are Responsable testcases or not? 6. Give me a Tracebility matrix documet & Deffination? 7. What is Error, Defect, Bug? 8. What is Smoke testing, Monkey testing, Sanity testing? 9. What is defference b/w Functionality testing & Regression testing? Give me a Example? 10. In your exp which type of defects you identify? 11. Tell me a defects for load testing,Security testing? 11. What is defference b/w System testing & User acceptance testing? 12. How many test cases write per a day& for one project how many testcases write you? 13. A professor has introduce some cources in college How to write test case for this requirement? 14. Write a test case for ATM Meachane? 15. Which configuration tool you used in .Net Application & Java based Applications? 16. What is the difference b/w Client server & Web based Application? 17. What is two tier & three tier application?Give me a example? 18. What is the defference b/w Java & J2ee? 19. Which model life cycles you used for Development & Testing? 20. Explain Development & Testing life cycles? 21. How to connect data table from QTP? 22. How QTP recognize Dynamic objects? 22. Which Atomation Frame work can you invoved in QTP& Explain me? 23. How QTP Tool Identify objects? 24 What is the difference b/w Check point & Out put value in QTP? 25. When did you give High Priority & High Seviority High Priority & Low Seviority High Seviority &High Priority High Seviority & Low Seviority?
write testcases for open dialogbox
what is test summry report ?plz explain?
1. Write configuration tests for a web based application. 2. How does a plane turn on ground? Explain with logic. 3. How would you test the volume control for a music system? 4. You have been given an application and you have only 15 mins to test the application. How would you do the testing? 5. Your machine, which is on a network has been disconnected. How you debug the problem? 6. What is the sum of numbers from 1 to 1000? 7. What is the probability that on rolling four dices same number appears on all dices? 8. You have been given 8 identical balls out of which one of them is heavier. How would find the heavier ball in the least number of tries with the help of a balance? Explain 9. There is a disc which has been painted half black and half white. You have been given sensors which could detect white or black colors. The disc is revolving in either clockwise or anticlockwise direction with variable angular speed. Find the minimum number of sensors required to determine the direction of rotation of the disc. 10. 64,54,42,31,20 which number does not fit in the series?