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
How can you do the usability testing?
How do you scope,organise and execute a test project.
what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???
what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?
Katari your questions was really helpful could you please send the questions and answers with them . Can anyone sends the top 30-40 question and answers for the interview purposes
what types of testing you performed in transfer funds module....
What is integration level testing?
Explain the sub-genres of performance testing?
wat is meant by frontend and backend testing
what is configuration management tool - send to thanu_santo@rediffmail.com. what is testing senarios
How to integrate Bugzilla with QTP?
Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..
What is fuzz testing?
What is remedy testing,expalim that and how can use that
How do you scope, organize, and execute a test project?