<P> With the help of these techniques, the functionality of the database can be tested thoroughly . </P> <P> Pros and Cons of black box testing include: Test case generation in black box testing is fairly simple . Their generation is completely independent of software development and can be done in an early stage of development . As a consequence, the programmer has better knowledge of how to design the database application and uses less time for debugging . Cost for development of black box test cases is lower than development of white box test cases . The major drawback of black box testing is that it is unknown how much of the program is being tested . Also, certain errors cannot be detected . </P> <P> White - box testing mainly deals with the internal structure of the database . The specification details are hidden from the user . </P> <Ol> <Li> It involves the testing of database triggers and logical views which are going to support database refactoring . </Li> <Li> It performs module testing of database functions, triggers, views, SQL queries etc . </Li> <Li> It validates database tables, data models, database schema etc . </Li> <Li> It checks rules of Referential integrity . </Li> <Li> It selects default table values to check on database consistency . </Li> <Li> The techniques used in white box testing are condition coverage, decision coverage, statement coverage, cyclomatic complexity . </Li> </Ol>

The testing technique that deals with the internal logic and structure of the code is called