SPONSORS:






View RSS Feed

Madhava verma dantuluri

Database testing overview

Rate this Entry
by , 01-24-2014 at 02:34 AM (692 Views)
Database testing basically include the following.

1) Data validity testing.
- Field type validations
- The field size validations
2) Data Integrity testing
- Check when u r enters the data in the front-end it is stored in the database or not.
- Check constraints
3) Performance related to data base.
- Verify the query execution time
- Indexes are done or not
4) Testing of Procedure, triggers and functions.
- Triggers is fired perfectly or not
- Check the stored procedures for correct result

Few pointers as below:
1. First of all you have to understand the functional requirement of the application thoroughly.
2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), triggers used(if any), stored procedures used (if any), input parameter used and output parameters used for developing that requirement.
3. After knowing all these things you have to write the test case with different input values for checking all the paths of SP.
Categories
Uncategorized

Comments

  1. Andy79's Avatar
    • |
    • permalink
    Very good summarized view of Database Testing. Thanks!

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:24 PM.

Copyright BetaSoft Inc.