Entries from July 2010

What are the different stages involved in Database Testing

On July 31, 2010 / By admin / In Database Testing / No Comments
verify field level data in the database with respect to frontend transactions verify the constraint (primary key,forien key ….) verify the performance of the procedures verify the triggrs (execution of triggers) verify the transactions (begin,commit,rollback) Read More...

What steps does a tester take in testing Stored Procedures?

On July 30, 2010 / By admin / In Database Testing / No Comments
First the tester should to go through the requirement, as to why the particular stored procedure is written for. Then check whether all the required indexes, joins, updates, deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like Read More...

How do you test whether the database is updated as and when an information are added in the front end?Give me an example?

On July 29, 2010 / By admin / In Database Testing / No Comments
It depends on what level of testing you are doing.When you want to save something from front end obviously, it has to store somewhere in the database You will need to find out the relevant tables involved in saving the records. Data Mapping from front end to the tables.Then enter the data from front end Read More...

How do you test whether a database in updated when information is entered in the front end?

On July 28, 2010 / By admin / In Database Testing / No Comments
It depend on your application interface.. 1. If your application provides view functionality for the entered data, then you can verify that from front end only. Most of the time Black box test engineers verify the functionality in this way. 2. If your application has only data entry from front end and there is no Read More...

SEO Powered By SEOPressor