Suilien520

 Profile Answers by Suilien520 

• Jun 10th, 2008

 

you need to conduct both black box test and white box test.
the black box testing should include testing incoming data value and outgoing data value from data queries, store procedure and views.
the white box test should include unit test for store procedure function, trigger, database schema element, default value for column

Nitinkk

 Profile Answers by Nitinkk 

• Aug 27th, 2009

 

For DB Testing Manual process.

• O/R mappings (including the meta data)
• Incoming data values.
• Outgoing data values (from queries, stored functions, views ...)

kurtz182

 Profile Answers by kurtz182 Questions by kurtz182

• Dec 19th, 2009

 

The answer to this question differs between company and project.  In general, testers may need to understand all or any combination of the following things relating to the application under test:

TASKS RELATING TO DATABASE

1) Data Integrity:  Once a value undergoes an Update, Insert or Delete, the database should be verified for changes performed on related entities such as foreign key, primary key, as well as any data that depends and may be modified by it.
 
2) Stored Procedures:  Every stored procedure that impacts the application should be tested.

3) Type Test: These tests simply verify that the data types used in the database are conform to specifications.

4) Event-driven Test:  Event-driven actions like triggers or scheduled actions need to be tested. Here, a tester needs to set up the conditions that trigger the event and verify its reponse.  This may or may not require direct involvement with the database.

5) Input Item Verification: All of this testing may be performed on the application itself, but verifying the database with views and queries may also substantiate your test efforts.

WHAT A TESTER NEEDS TO KNOW

1) Database schema associated with application
2) Constraints on tables
3) Views
4) Queries and joins
5) Stored procedures
6) Triggers and scheduled tasks

Jeff Kurtz