what is meant by database testing?
what is the strategy to be followed for database testing?

Answers were Sorted based on User's Feedback



what is meant by database testing? what is the strategy to be followed for database testing?..

Answer / nataraj jalasutram

Data base testing basically include the following.
1) Data validity testing.
2) Data Integrality testing
3)Performance related to data base.
4) Testing of Procedure, triggers and functions
How to Test a database manually?
Observing that operations, which are operated on front-end
is effected on back-end or not.

The approach is as follows:
While adding a record thr' front-end check back-end that
addition of record is effected or not.
So same for delete, update,

Ex:Enter employee record in database thr' front-end and
check if the record is added or not to the back-end
(manually).

Is This Answer Correct ?    13 Yes 2 No

what is meant by database testing? what is the strategy to be followed for database testing?..

Answer / santy

to validate the data in the database, to validate the data
integrity and performance of procedure

Is This Answer Correct ?    8 Yes 3 No

what is meant by database testing? what is the strategy to be followed for database testing?..

Answer / indranil

In DB testing we need to check for:

1. The field size validation.
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures.
5. The field size defined in the application is matching
with that in the db.
6. Relevance of search results
7. Data integrity
8. Data validity
9. Data recovery
10. Security

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Manual Testing Interview Questions

can you tell me how to write test cases for payments, receipts, inward clearing, outward clearing, A/c statements ?

0 Answers  


What are the review documents used for testing?

0 Answers  


What is test data

3 Answers  


How do we find Effectiveness of Test Cases..Thanks in advance...

4 Answers   Siemens,


when will tester do the smoke testing?

2 Answers  






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

2 Answers   HCL, iGate,


Do I have to write separate test cases for entering special characters, blank space, numbers in First name field ? Or should I create single test case for it? If yes then how?

4 Answers  


What is a test data? Give examples

5 Answers  


who are all participate in preparing SRS documents? what are the datas present in SRS documents? who will create test plan ? what are the inputs for test plan & test case?

6 Answers   TCS,


The company has software running in its production environment that was designed and tested on its quad- processor servers with 16 GB of RAM. In order to meet budget constraints, its disaster recovery plan calls for this same software to be installed on functionally identical servers, which are dual-processor with 12 GB of RAM. The test group has been tasked with confirming that the software is going to work on the hardware proposed in the disaster recovery plan. -what testing types is being used in the scenario above?

2 Answers  


What is Mutation testing? When it can be done?

6 Answers   HTC,


Hi! I got an interview call for the post of Trainee QA engg .The interview is on Monday(27/08/07).There is going to be a technical written test followed by an interview on Monday.Can anyone plz tell me what exactly is the technical written test for QA like,is it objective or theoretical based. PLZZZZZ reply as early as possible ---- Its URGENT. -- SK

2 Answers   IBM,


Categories