Topic: Database Testing

Message

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.

Author	Message
tanushree Senior Member Joined: 04Apr2007 Online Status: Offline Posts: 2160	Topic: Database Testing Posted: 25Oct2007 at 4:34am
	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. Post Resume: Click here to Upload your Resume & Apply for Jobs

	IP Logged

achan Newbie Joined: 24Jan2008 Location: Canada Online Status: Offline Posts: 1	Posted: 24Jan2008 at 7:49am
	Hi Tanushree I am new to database testing, so i am not clear about how to test #2and #3 can you please give an example for these thanks achan
	IP Logged

aamirkhan Newbie Joined: 21Feb2008 Location: Pakistan Online Status: Offline Posts: 1	Posted: 21Feb2008 at 11:57pm
	Check Constraint: A check constraint (also known as table check constraint) is a condition that defines valid data when adding or updating an entry in a table of a relational database. A check constraint is applied to each row in the table.
	With Kind Regards, Muhammad Aamir Khan
	IP Logged


One Stop Testing Forum : Types Of Software Testing @ OneStopTesting : Functional Testing @ OneStopTesting