Print Page | Close Window

Database Testing

Printed From: One Stop Testing
Category: General @ OneStopTesting
Forum Name: Announcements @ OneStopTesting
Forum Discription: Get to know the latest happening at One Stop Testing Forum.
URL: http://forum.onestoptesting.com/forum_posts.asp?TID=3618
Printed Date: 28Dec2024 at 9:02am


Topic: Database Testing
Posted By: Jayalakshmi
Subject: Database Testing
Date Posted: 13Nov2007 at 5:14am
Hi,
Can anybody tell me how to do Database Testing?Is it done by testers or by the DBA's.
Is it same as data verification.
If not can anyone tell how we do DataBase testing
Thanx
Jayalakshmi


Replies:
Posted By: QualityByDesign
Date Posted: 13Apr2008 at 12:05pm
Hi Jayalakshmi,
Following are verifications done in DB testing(remember DB testing is a verification+validation step in V-model.This means even before you start breaking the client reqmts. into modules you have to check if these are sustainable with the DB asked by client.
And also testing the reqts. after the coding begins.

DB Testing covers the following points.
Server Security
Database Connections Check
Table Access Control Check
Restricting Database Access Check
Table Integrity Check
Column Data Type Check

Most of these checks require considerable DB knowledge,it is advisable to be done by a DBA,Except the last two iwhich is done using SQL by Testers.


-------------
"Act in haste and repent at leisure.
Corollary1: Code too soon and re-compile forever.
Corollary 2:Test too fast and debug forever"

Posted By: ranupam
Date Posted: 14Apr2008 at 6:42pm
Hi Jayalakshmi
 
Simple Defination for Database testing :
 
What ever the input we give in the client side ,we will be verify the that .how it's refelected in the database .is it going into the correct table .it's verification of datawhich every we give in the client side.
 
Is done by testers with the help of DBA's
Data verification is part of Database testing
 
Regards
 


-------------
Ravi C Anupam
SAP Test Analyst
KPMG Australia


Print Page | Close Window