Interested to Buy Any Domain ? << Click Here >> for more details...
what actual a tester perform in database testing?(its very
urgent pls)
- 4 Answers
- 9170 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
what is agile model and spiral maodel?pls explain with an example?
Which of these techniques is not useful for partition testing at the class level Option 1 attribute-based partitioning Option 2 category-based partitioning Option 3 equivalence class partitioning Option 4 state-based partitioning
What is ofx testing?
Sentence "Working from onsite is effective" is growing in IT field. How do we bring that knowledge to offshore and do an effective job in Offshore?
What is the full form of cmmi?
What is sanity?
Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.
what is the critical defect in telecom domain?help me out from this prob its very urgent
what will be verification and validation test cases for yahoo login page (only functional test cases)? Please explain in details.
What is junit & api?
What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing
What is the typical situation u faced while collecting the test data?
approx how long a simple website take time just for manual testing including report generation.
how to write manual testcases for download the files from the template. for example:from product cost enddate
14.What is function point breakdown?
