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
About Hierarchy level in your company.
What is CVS and why it is used?
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.
Enlist some bug status along with its description?
What kind of testing to be done in client server application and web application? Explain
Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?
what is test strategy,test plan and test policy?Does anyone have dummy documents or any links that gives more idea about these?I am a beginner...interested in learning more abt testing.plz help and encourage me........!
1.what is a test condition ?
What is the Testing strategy for testing client server applications/products?
How do you get programmers to build testability support into their code?
in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application
name poneno dept sun 9894433467 computer This is the xls sheet a programs written to transfer this data into database write test cases and test scenario?
How do you know the code has met specifications?
How quickly we need to fix the bug? Or how soon the bug should get fixed?
can anybody tell me what is release process of company? release note?