Answer / 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.

Answer / purni

In the database testing, we have to write SQL queries to
retrieve and validate the data for data consistency and
integrity. When testing the database, tester usually work on
the copy of the application. We have to prepare the test
data to save the data in the back end and work on it. This
include Inserting, validation, verification, consistency and
integrity.

Answer / jyothsna

Actually, what a tester performs in database testing is
self explanatory. He tests the database :) As a tester you
should test if the data is inserted in the table or not
after insert statement has been executed. if so, compare
the number of rows between source and target....
For stored procedures, execute a stored procedure
(parameterized) and compare the result with the data in the
table. If it matches, then test passes, else fails. Also,
try to execute the same procedure with different parameter
values just to test the functionality.
For triggers, for example, a trigger action is to insert a
record in a table, activate the trigger by its respective
action and test if a record has been inserted in that table
or not. and it goes on.........

Answer / venkat rao sandu

the actual tester will perform on data base is...
check weather all required data base connections connected
properly...or not

1.How will u write traceability matrix? 2.What is Test summary Report…? 3. What is Test Closure report…? 4.What are the Testing methodologies that u have followed in your project ? plz...........do reply...............

1 Answers   Virtusa,

---

What is Check list for review test cases ?

1 Answers  

---

what are the 3 test tool categories and describe what each can do.

0 Answers  

---

What is d differences between sanity and smoke testing with xample?If anyone knows pls ans dis ques

5 Answers  

---

Tell me about Agile scrum and what is your role in Scrum ?

0 Answers   IG Infotech,

---

Suppose u found a bug which a developer could not reproduce and it is reproducing on your pc whenever tried , then in this siyuation what will be the status of the bug, and what u r going to do for that bug.

4 Answers   Flextronics, Syntel,

---

An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000 Can you please explain in brief, how to do equivalance class?

4 Answers   ISTQB, Tech Mahindra,

---

what is integration testing and end to end testing?

1 Answers   Sapient,

---

What is CMM-1,2,3,4,5 Level Company? How much levels are there like CMM?

3 Answers  

---

Did you ever worked with BA's?

1 Answers   Standard Bank, Wells Fargo,

---

what is UI testing

15 Answers   Infosys, Infotech,

---

What should be done after writing test cases?

6 Answers   iSoft,

---