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

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

Question Posted / rajendra

3 Answers
10690 Views
MedePresence, I also Faced
E-Mail Answers

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