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.

ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience

1904

---

Write a Test scenario for Outlook Search functionality.

3002

---

i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.

5616

---

About Testing

2400

---

I have cleared written test and one Technical round in one company? now i have to face an Client Round through telephony? Any body have faced client round, how will it be , wil they ask technical or is it only formality round? im nervous, plz let me know wat all they may ask? i have this round on monday?

2917

---

Explain the components of a test plan?

1132

---

How to find bug in photos and videos ??

2274

---

What are the properties of a good requirement?

2038

---

Define brain stromming and cause effect graphing?

1154

---

Hi,Please can any one tell me about SAP Testing concepts.

2008

---

hi what are the test cases for web application..i need these example..please..mail me at mina_ims@yahoo.com

1999

---

Hi friends, currently i am working with banking domain project in the part of testing..what kind of questions will be ask at interviews.. can anybody listout the project oriented questions which are asked in interviews...

3912

---

How to write test case for view the table(i.e it is already stored in database and see the content in the table)

2554

---

what is traceability matrix and its usefulness

4140

---

after completeing testing ,what would u deliver to the client?

2107

---