what actual a tester perform in database testing?(its very
urgent pls)
- 4 Answers
- 7554 Views
- I also Faced
- E-Mail Answers
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
Name three reasons why the tester may choose to record in Context Sensitive mode.
How we allocate the priority(Blocker, Critical, etc.,) in Testing?
Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com
in transfer funds module, how you come to know that amount has been transferred successfully or not....explain in detail
what is the difference between Test-bed and test topology?
what type of quetion may be asked for experienced person in manual tester of 1 year?
Can you explain tailoring?
what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply
Write a set of test cases to test youtube?
IF ASCII_CODE_OF_ENTERED_CHAR is less than 44 THEN reject it ELSE IF ASCII_CODE_OF_ENTERED_CHAR is greater than 56 THEN reject it ELSE it's a digit, so accept it Which one of the following sets of ASCII codes do you use to test the sample code above WITHOUT redundant coverage?
diff b/w desktop based testing & web application testing
What are the disadvantages of manual testing?
Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position
What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?
What ishigh severity, low priority bug?
