Interested to Buy Any Domain ? << Click Here >> for more details...
what actual a tester perform in database testing?(its very
urgent pls)
- 4 Answers
- 8848 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.........
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / venkat rao sandu
the actual tester will perform on data base is...
check weather all required data base connections connected
properly...or not
| Is This Answer Correct ? | 0 Yes | 6 No |
what is the difference between testing and software testing? what is testing methodology? how can we do reliability testing? plz reply to this id sari.swapna@gmail.com
Hi.. I am working as a tester in a small company. I have 2+ yrs exp in manual. we are using only excel sheet for preparing bug report. Now i want to search job in other company..I dont have any idea about bug tracking tool..should i know abt any bug tracking tool to get better job?
Can anyone listout major scenarios for a payment submission web page??? Can anyone tell me that yahoo messenger is a web-based application or a windows based application???
What are the Testers Responsbile?
In an ATM machine , after entering pin -> not able to withdraw money. What are all the possible reasons. Debug
If Rohan likes 400 & does not like 300, he likes 100 but not 99, he likes 2500 but not 2400, what does he like? 1. 900 2. 1000 3. 1100 4. 1200 Please give answer with proper explanation!
can any one give the example for high severity high priority high severity low priority low severity high priority low severity low priority
How would you test a WINDOWS application...? & How you are going to test a WEB applicaiton...?
As you are working with cmmi level 5 company ,can you tell me what processes you r following as QA engineer?
what is mean by test preparation? and explain it?
What do you do if the bug that you found is not accepted by the developer and he is saying its not reproducible.
Test case for Google home page
Automation Testing 
