Database Testing

46 %
54 %
Information about Database Testing

Published on April 13, 2007

Author: upkar


Slide1: <![CDATA[ Database Testing Author: Krishna Yannam Asst. Manager (Quality)]]> Slide2: <![CDATA[ Database Testing - DB Updates Database Testing mainly concentrates on following: Data Integrity test Stored Procedure test Type test Data Size Test Event Driven Item Test Input Item Verification Close Show]]> Slide3: <![CDATA[ Data Integrity Test Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Once a value undergoes any of the above actions (update / Delete / Insert) the database should be verified for the changes performed on related entities i.e., Foreign key / Primary key and all dependent entities  BACK]]> Slide4: <![CDATA[ Every Stored Procedure is to be tested separately for its functionality ( Based on Separate functions it performs ) Stored procedures need to be broken up into Action Items based on Functions and then Each action item needs to be tested separately as the results of Complete Stored procedure. Execution may differ from the results obtained by partial execution. This also helps in validating the modularity of Code (White Box). Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Store Procedure Test]]> Slide5: <![CDATA[  BACK In the case of stored procedures, to come up with test cases one can consider the following:   1. The no. of arguments being passed 2. The data type of each of the arguments being passed 3. The order of the arguments being passed 4. The return value 5. The data type of the return value   Based on these you can write both positive and negative test cases, consider a simple example of a stored procedure taking 2 numbers as input and returning the sum of the 2 numbers Store Procedure Test]]> Slide6: <![CDATA[  BACK This test is performed to verify that the data types used by the DBA are same as expected by agreed upon by the developer. Often the data types chosen by developers are not the same as suggested by database administrators , especially for the fields like A) Phone (Num./Text) B) Description (Large Text) These kinds of mismatches often do not effect the functionality and normal execution of code, but prove to be very Costly during Updating of product or during addition of features to the existing modules Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Type Test]]> Slide7: <![CDATA[  BACK Performance of Data size testing is often done only at the front end during the unit testing , but it is essential to perform it at back end separately . This ensures smooth transition while appending functionality and integrating modules as during these Phases , the data is passed to the system with direct user interaction and bypassing front end validation. Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Data Size Test]]> Slide8: <![CDATA[  BACK Event Driven Actions (Triggers or Scheduled Actions) needs to be tested on two parameters. A) Events that trigger these actions: Here QA needs to check the events on which any of the trigger can get fired/executed . This testing can be done with the help of DBA also . B) Actions performed by the above stated events. Here the contents of such stored procedures or scheduled actions are verified for the functionality . Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Environment Driven Item Test]]> Slide9: <![CDATA[  BACK This is the process of verification of the input items (Though this is not totally a part of database testing , but this has to be performed essentially during database testing of the Web based applications. Often it is seen that the input items (Text Box / RTB / Combination Box / Active-X controls) are tested for validation only at front end (Screen testing) but these are again to be tested with junk Character values to confirm that they do not push in such characters which the databases Often misrepresent or Replace with other characters (this testing can partially be performed during Unit testing also by the developer. Actions: Updating / Deletion / Fresh Insertion/Display of new Screen /Time bound actions. Input Item Verification]]> Slide10: <![CDATA[]]>

Add a comment

Related presentations

Related pages

Database testing - Wikipedia, the free encyclopedia

Purposes. Database testing usually consists of a layered process, including the user interface (UI) layer, the business layer, the data access layer and ...
Read more

Database Testing: How to Regression Test a Relational Database

Relational database management systems (RDBMSs) often persist mission-critical data which is updated by many applications and potentially thousands if not ...
Read more

All About Database Testing – Why to Test, How to Test ...

All about database testing - In this article we will learn all about DB testing. Why to test- How to test- What to test : These are some of the aspects we will
Read more

Database Testing - DbUnit – About DbUnit

Database Testing. Richard Dallaway notes about database unit testing inspired me the realization of the DbUnit framework. I think this is a very good ...
Read more

Database Testing

Database Testing Guide: Computer applications are more complex these days with technologies like android and also with lots of smart phone apps.
Read more

Database Testing - Tutorials for Spark, Spark SQL, R ...

What is Database Testing? Database testing involves the retrieved values from the database by the web or desktop application. Data in the User Interface ...
Read more

Database(Data) Testing Tutorial with Sample TestCases

User-Interface testing. Database or Data testing. This type of testing is also known as Graphical User Interface testing or Front-end Testing. This type of ...
Read more

How to do real database testing (10 tips to perform ...

SOFTWARE TESTING SPACE - One of the most popular software testing blogs with quality articles on test automation and performance testing using ...
Read more

Tutorial Database Testing using SQL | SQL for Testers ...

Download the “SQL For Testers” tutorial from here. Before going through chapters 2 to 6, one should know the basics of SQL
Read more