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
1.Enlist the types of testing performed for any window in sequence? 2.Use of edit_get_list function 3.Accuracy & Precision
Explain accessibility testing and its importance in the present scenario.
Can you explain regression testing and confirmation testing?
Can u give me explanation about section 508 testcase and Testcase for this section. It need a details checklist for the same Manimozhi
Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.
What Is risk Based testing?
Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance
Hi, this is murthysharma. I need very urgently about some terms which are used in use cases? Plz give reply to me, if any body know, It is really very very urgent. 1. what is the difference between basic flow,exception flow and alternative flow? 2.what are non-functional requirements in use cases? 3.what are exceptions, special requirements, business rules, assumptions, constraints. Kindly give me with the example. Bcoz, I am very new to this use cases. thanks in Advance. Regards, M.MurthySharma
I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???
What is mean by incident logging system ?
What are the basic forms of variations?
Describe to me what you see as a process. Not a particular process, just the basics of having a process.
What is your approach when requirements change continuously?
1)What are the QA procedures followed 2) Write test cases on a weatherreport.com web page that has only two dropdown and a submit button, Fist drop down is a countries and second is metros in the selcted countries.When proper selection si doen and submitted it shows weather report of that metro.? 3)Write test cases on Mobile Alarm Module? 4)Write test cases on Company Water Bottle?
How to test the Online Games?? Suggest tricks. I have experience in server-client application testing.