database testing

what is exactly database testing?
Do you write different/seperate set of test cases for database testing?
say if we have objects like an update button or add or delete button etc., then we will preparing test cases for the operations of these type of buttons

Database testing is to test if the actions in the application is correct and complete on its database.

Database testing confirm the integrity of database.These is no any redundant data, required data column should not null always etc.

please coulde you explaine more
coulde you give me the main idea of the database testing? how it's work ?, what exactly testing for ?what are the benefits that we get it from database testing? what is the most common database testing tools?

hi freestyle,

As per my understanding u need to know how database testing is performed.

For ex: you have a login form the user should provide username and password
the username and password will be stored in the database.

1. check out whether primary key is assigned to the table users(which contains username and password).
2. check out the valiadation there in teh database, suppose i am assigning the username field should accept 50 characters username varchar(50), it indicates that the user name field should not accept vaules more than 50.

If i am specifying the username more than 50 in the front end and i save it. From the front end, but please note username field should accept only 50 characters, more than 50 characters specified from the database should be truncated from the database.

3.Check key validation for the table

Please note : I have mentioned only few things for database testing

If u have any doubts please let me know i can help u as much as i can

Thanks
Deepasree

Deepasree, gud exmaple here for DB testing .
Can you how to test a referential integrity in the DB Testing

hai friend,

[QUOTE=testingplanet;47146]Deepasree, gud exmaple here for DB testing .
Can you how to test a referential integrity in the DB Testing[/QUOTE]

you need primary key else foreign key.

Thanks
Deepa