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

My questions are- 1. If we have 1 week time in hand what will be the approch of testing. 2. If we have very lesstime in hand then how we will do the regration testing. 2. When there is a change in requirement in module A then what should be the approch to change in that module and in other module like B,C etc an whow we update the test case pls explain the scenario in detail. 3.How do you confirm that for perticular funtionality all the test cases has been written. Thanks

1 Answers   IBM,

---

9. Are there materials you would like to see added to the Web site? Which ones?

0 Answers  

---

How do you scope ,Organize and execute a test project?

1 Answers  

---

wt r the types of testings r belongs to black box testing, wt r the types of testings r belongs to white box testing and wt r the types of testing r belongs to both.

4 Answers  

---

What is bucket testing?

0 Answers  

---

I am doing manual testing for one website application. already i had prepared test case report,bug tracking report. now i need to perform functional testing of the application and prepare function test report. so can u send one model of the functional test report to me.. it is very helpful to me. my id is sunaruna84@gmail.com

0 Answers   SoftSquare,

---

Difference between manual testing and system testing

2 Answers   Symphony,

---

How to prepare web applications use case document.can you send the some sample use case document for web application Project?

0 Answers  

---

Can you explain how tpa works?

0 Answers  

---

What do you mean by coverage and what are the different types of coverage techniques?

1 Answers  

---

Write TestCases for ATM Machine ?

1 Answers   IBM,

---

Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..

1 Answers  

---