what actual a tester perform in database testing?(its very
urgent pls)
Answer Posted / nilutpal
To perform DB testing, a tester may follow below steps -
Step-1: Check pre-requisites - Application and Database
should be present, DB should be integrated with
application, Test data should be ready or enter data
through application.
Step-2: 1. Open database – SQL/Oracle
2. Open query editor.
3.Select the database
4.Enter the query to check test data
Step-3: You have to equipped with below -
1. queries to compare records,
2. compare record counts,
3. Check primary key and foreign key(s)
4. Table descriptions and data-types as well as its
properties of fields
5. check integrity,
6. Check joins to establish relations
7. identify orphaned records
8. By using sql profiler,you can check which SP is called
for which event.
9. Check whether records are properly stored or not in
there respective tables.
10. Check indexing.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the properties of a good requirement?
How to Generate Test Case for Shopping Cart?
In how many ways you perform batchtesting ?
What is the difference between three tier and two tier application?
what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???
what are the testing appraoch that you have tested for Bread toaster
Explain about PET Model?
How should your staff be managed? How about your overtime?
What type bugs you will find in integration testing with example?
Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance
what is the difference between PEGA based web application testing versus web application testing?
What are testing techniques? What is difference between general and specific?
What are the review documents used for testing?
.In languages testing, what is the fixed part and changing part?
What is the procedure of manual testing?