Ins & Outs of Software Testing Technology Under One Roof
MENUMENU
  • Home
  • Certifications Resources
    • HP QTP Certifications
    • PMI PMP Certification Preparation
    • PMI PMP Certification Exam Practice Question Papers
    • CSTE Certifications
    • IBM RFT Certification
    • ISTQB Certifications
    • ISTQB Advanced CTAL Test Manager Exam-Crash Course
    • ISTQB Advanced CTAL Test Analysts Exam-Crash Course
    • ISTQB Foundation Level Exam Crash Course
    • ISTQB Foundation Exam - Sample Question Papers
    • ISTQB Agile Tester Extension Exam
    • ISTQB Advanced Test Managers Exam Preparation
    • ISTQB Advanced CTAL Exam Preparation
  • Knowledge Center
    • Career Building in Testing
      • Qualities of Test Personnel
      • Career Shaping in QA
    • Interview Preparation - FAQ
      • FAQ - Rehearsal of QTP in 1 Hr.
      • FAQ - Rehearsal of LoadRunner in 1 Hr.
      • FAQ - Common HR Questions
      • FAQ - Tricky HR Questions
      • FAQ - Software Testing and QA
      • FAQ - QTP - Quick Test Professional
      • FAQ - HP Load Runner (Controller)
      • FAQ - HP Load Runner (VuGen)
      • FAQ - HP Load Runner (Basics)
      • FAQ - RFT - Rational Functional Tester
      • FAQ - Database Testing
      • FAQ - Silk Test
    • Flamboyant Topics
      • Software Bugs
      • White Box Testing
      • Gray Box Testing
      • Black Box Testing
      • Website Testing
      • Database Testing
      • SDLC & STLC
      • Risk Analysis
      • Test Cases
      • Software Development Models
      • Achievements
    • QA Best Practices
      • Software Testing - General
    • New Technologies
      • Robotic Process Automation
      • Big Data
    • Glossary Encyclopedia
      • Encyclopedia - Software Testing Terms
      • Glossary Encyclopedia - Linked articles
    • Favorite Industry Topics
      • Global Recession
  • Automation Testing
    • Automation Testing
      • Review your RFT Skills
      • Review your LoadRunner HPO-M49 Skills
      • Review your LoadRunner HPO-M48 Skills
      • Review your Performance Center HPO-M47 Skills
      • Review Your HP QTP / UFT Skills
      • Review Your Quality Center Skills
      • Automation Frameworks
      • Ins & Outs of Automation
    • Hot Automation Tools
      • Katalon Studio
      • IBM Rational Functional Tester
      • HP LoadRunner
      • HP WinRunner
      • HP Quality Center
      • HP Quick Test Professional / UFT
      • Functional Testing Tools - Linked Articles
  • Manual Testing
    • Manual Testing
      • Various Approaches
      • Test Planning
    • Software Testing Startup Kit
      • Startup Articles
      • Basics of Testing
      • Quality Perspective
      • Types of Testing
      • Testing Tools
      • Types of Software Testing - Linked Articles
    • Quality Systems
      • QA Managers Skill Test
      • Software Testing Skill Test
      • Quality Management
      • CMM & CMMI
      • Verification & Validation (V&V)
      • Quality Perspective - Linked Articles
    • Templates & Checklists
      • Templates for Download
      • Checklists for Testers & Developers
      • Checklists for QA Managers & Team Leads
  • Tutorials
    • Tutorials: HP QTP / UFT
    • Tutorials: HP LoadRunner
    • Tutorials: IBM Rational Functional Tester
  • Quizes
    • HP QC Expert Level Quiz
    • QTP Basic Level Quiz
    • QTP Intermediate Level Quiz
    • QTP Expert Level Quiz
    • RFT - Rational Functional Tester Quiz
    • Software Testing Basics Quiz
    • ISTQB Certification Quiz
    • CSTE Certification Quiz
  • Free eBooks
    • eBooks: HP QTP/UFT
    • eBooks: Manual Testing
MENUMENU
  • Home
  • Certifications Resources
    • HP QTP Certifications
    • PMI PMP Certification Preparation
    • PMI PMP Certification Exam Practice Question Papers
    • CSTE Certifications
    • IBM RFT Certification
    • ISTQB Certifications
    • ISTQB Advanced CTAL Test Manager Exam-Crash Course
    • ISTQB Advanced CTAL Test Analysts Exam-Crash Course
    • ISTQB Foundation Level Exam Crash Course
    • ISTQB Foundation Exam - Sample Question Papers
    • ISTQB Agile Tester Extension Exam
    • ISTQB Advanced Test Managers Exam Preparation
    • ISTQB Advanced CTAL Exam Preparation
  • Knowledge Center
    • Career Building in Testing
      • Qualities of Test Personnel
      • Career Shaping in QA
    • Interview Preparation - FAQ
      • FAQ - Rehearsal of QTP in 1 Hr.
      • FAQ - Rehearsal of LoadRunner in 1 Hr.
      • FAQ - Common HR Questions
      • FAQ - Tricky HR Questions
      • FAQ - Software Testing and QA
      • FAQ - QTP - Quick Test Professional
      • FAQ - HP Load Runner (Controller)
      • FAQ - HP Load Runner (VuGen)
      • FAQ - HP Load Runner (Basics)
      • FAQ - RFT - Rational Functional Tester
      • FAQ - Database Testing
      • FAQ - Silk Test
    • Flamboyant Topics
      • Software Bugs
      • White Box Testing
      • Gray Box Testing
      • Black Box Testing
      • Website Testing
      • Database Testing
      • SDLC & STLC
      • Risk Analysis
      • Test Cases
      • Software Development Models
      • Achievements
    • QA Best Practices
      • Software Testing - General
    • New Technologies
      • Robotic Process Automation
      • Big Data
    • Glossary Encyclopedia
      • Encyclopedia - Software Testing Terms
      • Glossary Encyclopedia - Linked articles
    • Favorite Industry Topics
      • Global Recession
  • Automation Testing
    • Automation Testing
      • Review your RFT Skills
      • Review your LoadRunner HPO-M49 Skills
      • Review your LoadRunner HPO-M48 Skills
      • Review your Performance Center HPO-M47 Skills
      • Review Your HP QTP / UFT Skills
      • Review Your Quality Center Skills
      • Automation Frameworks
      • Ins & Outs of Automation
    • Hot Automation Tools
      • Katalon Studio
      • IBM Rational Functional Tester
      • HP LoadRunner
      • HP WinRunner
      • HP Quality Center
      • HP Quick Test Professional / UFT
      • Functional Testing Tools - Linked Articles
  • Manual Testing
    • Manual Testing
      • Various Approaches
      • Test Planning
    • Software Testing Startup Kit
      • Startup Articles
      • Basics of Testing
      • Quality Perspective
      • Types of Testing
      • Testing Tools
      • Types of Software Testing - Linked Articles
    • Quality Systems
      • QA Managers Skill Test
      • Software Testing Skill Test
      • Quality Management
      • CMM & CMMI
      • Verification & Validation (V&V)
      • Quality Perspective - Linked Articles
    • Templates & Checklists
      • Templates for Download
      • Checklists for Testers & Developers
      • Checklists for QA Managers & Team Leads
  • Tutorials
    • Tutorials: HP QTP / UFT
    • Tutorials: HP LoadRunner
    • Tutorials: IBM Rational Functional Tester
  • Quizes
    • HP QC Expert Level Quiz
    • QTP Basic Level Quiz
    • QTP Intermediate Level Quiz
    • QTP Expert Level Quiz
    • RFT - Rational Functional Tester Quiz
    • Software Testing Basics Quiz
    • ISTQB Certification Quiz
    • CSTE Certification Quiz
  • Free eBooks
    • eBooks: HP QTP/UFT
    • eBooks: Manual Testing
Ins & Outs of Software Testing Technology Under One Roof
MENUMENU
  • Home
  • Certifications Resources
    • HP QTP Certifications
    • PMI PMP Certification Preparation
    • PMI PMP Certification Exam Practice Question Papers
    • CSTE Certifications
    • IBM RFT Certification
    • ISTQB Certifications
    • ISTQB Advanced CTAL Test Manager Exam-Crash Course
    • ISTQB Advanced CTAL Test Analysts Exam-Crash Course
    • ISTQB Foundation Level Exam Crash Course
    • ISTQB Foundation Exam - Sample Question Papers
    • ISTQB Agile Tester Extension Exam
    • ISTQB Advanced Test Managers Exam Preparation
    • ISTQB Advanced CTAL Exam Preparation
  • Knowledge Center
    • Career Building in Testing
      • Qualities of Test Personnel
      • Career Shaping in QA
    • Interview Preparation - FAQ
      • FAQ - Rehearsal of QTP in 1 Hr.
      • FAQ - Rehearsal of LoadRunner in 1 Hr.
      • FAQ - Common HR Questions
      • FAQ - Tricky HR Questions
      • FAQ - Software Testing and QA
      • FAQ - QTP - Quick Test Professional
      • FAQ - HP Load Runner (Controller)
      • FAQ - HP Load Runner (VuGen)
      • FAQ - HP Load Runner (Basics)
      • FAQ - RFT - Rational Functional Tester
      • FAQ - Database Testing
      • FAQ - Silk Test
    • Flamboyant Topics
      • Software Bugs
      • White Box Testing
      • Gray Box Testing
      • Black Box Testing
      • Website Testing
      • Database Testing
      • SDLC & STLC
      • Risk Analysis
      • Test Cases
      • Software Development Models
      • Achievements
    • QA Best Practices
      • Software Testing - General
    • New Technologies
      • Robotic Process Automation
      • Big Data
    • Glossary Encyclopedia
      • Encyclopedia - Software Testing Terms
      • Glossary Encyclopedia - Linked articles
    • Favorite Industry Topics
      • Global Recession
  • Automation Testing
    • Automation Testing
      • Review your RFT Skills
      • Review your LoadRunner HPO-M49 Skills
      • Review your LoadRunner HPO-M48 Skills
      • Review your Performance Center HPO-M47 Skills
      • Review Your HP QTP / UFT Skills
      • Review Your Quality Center Skills
      • Automation Frameworks
      • Ins & Outs of Automation
    • Hot Automation Tools
      • Katalon Studio
      • IBM Rational Functional Tester
      • HP LoadRunner
      • HP WinRunner
      • HP Quality Center
      • HP Quick Test Professional / UFT
      • Functional Testing Tools - Linked Articles
  • Manual Testing
    • Manual Testing
      • Various Approaches
      • Test Planning
    • Software Testing Startup Kit
      • Startup Articles
      • Basics of Testing
      • Quality Perspective
      • Types of Testing
      • Testing Tools
      • Types of Software Testing - Linked Articles
    • Quality Systems
      • QA Managers Skill Test
      • Software Testing Skill Test
      • Quality Management
      • CMM & CMMI
      • Verification & Validation (V&V)
      • Quality Perspective - Linked Articles
    • Templates & Checklists
      • Templates for Download
      • Checklists for Testers & Developers
      • Checklists for QA Managers & Team Leads
  • Tutorials
    • Tutorials: HP QTP / UFT
    • Tutorials: HP LoadRunner
    • Tutorials: IBM Rational Functional Tester
  • Quizes
    • HP QC Expert Level Quiz
    • QTP Basic Level Quiz
    • QTP Intermediate Level Quiz
    • QTP Expert Level Quiz
    • RFT - Rational Functional Tester Quiz
    • Software Testing Basics Quiz
    • ISTQB Certification Quiz
    • CSTE Certification Quiz
  • Free eBooks
    • eBooks: HP QTP/UFT
    • eBooks: Manual Testing
MENUMENU
  • Home
  • Certifications Resources
    • HP QTP Certifications
    • PMI PMP Certification Preparation
    • PMI PMP Certification Exam Practice Question Papers
    • CSTE Certifications
    • IBM RFT Certification
    • ISTQB Certifications
    • ISTQB Advanced CTAL Test Manager Exam-Crash Course
    • ISTQB Advanced CTAL Test Analysts Exam-Crash Course
    • ISTQB Foundation Level Exam Crash Course
    • ISTQB Foundation Exam - Sample Question Papers
    • ISTQB Agile Tester Extension Exam
    • ISTQB Advanced Test Managers Exam Preparation
    • ISTQB Advanced CTAL Exam Preparation
  • Knowledge Center
    • Career Building in Testing
      • Qualities of Test Personnel
      • Career Shaping in QA
    • Interview Preparation - FAQ
      • FAQ - Rehearsal of QTP in 1 Hr.
      • FAQ - Rehearsal of LoadRunner in 1 Hr.
      • FAQ - Common HR Questions
      • FAQ - Tricky HR Questions
      • FAQ - Software Testing and QA
      • FAQ - QTP - Quick Test Professional
      • FAQ - HP Load Runner (Controller)
      • FAQ - HP Load Runner (VuGen)
      • FAQ - HP Load Runner (Basics)
      • FAQ - RFT - Rational Functional Tester
      • FAQ - Database Testing
      • FAQ - Silk Test
    • Flamboyant Topics
      • Software Bugs
      • White Box Testing
      • Gray Box Testing
      • Black Box Testing
      • Website Testing
      • Database Testing
      • SDLC & STLC
      • Risk Analysis
      • Test Cases
      • Software Development Models
      • Achievements
    • QA Best Practices
      • Software Testing - General
    • New Technologies
      • Robotic Process Automation
      • Big Data
    • Glossary Encyclopedia
      • Encyclopedia - Software Testing Terms
      • Glossary Encyclopedia - Linked articles
    • Favorite Industry Topics
      • Global Recession
  • Automation Testing
    • Automation Testing
      • Review your RFT Skills
      • Review your LoadRunner HPO-M49 Skills
      • Review your LoadRunner HPO-M48 Skills
      • Review your Performance Center HPO-M47 Skills
      • Review Your HP QTP / UFT Skills
      • Review Your Quality Center Skills
      • Automation Frameworks
      • Ins & Outs of Automation
    • Hot Automation Tools
      • Katalon Studio
      • IBM Rational Functional Tester
      • HP LoadRunner
      • HP WinRunner
      • HP Quality Center
      • HP Quick Test Professional / UFT
      • Functional Testing Tools - Linked Articles
  • Manual Testing
    • Manual Testing
      • Various Approaches
      • Test Planning
    • Software Testing Startup Kit
      • Startup Articles
      • Basics of Testing
      • Quality Perspective
      • Types of Testing
      • Testing Tools
      • Types of Software Testing - Linked Articles
    • Quality Systems
      • QA Managers Skill Test
      • Software Testing Skill Test
      • Quality Management
      • CMM & CMMI
      • Verification & Validation (V&V)
      • Quality Perspective - Linked Articles
    • Templates & Checklists
      • Templates for Download
      • Checklists for Testers & Developers
      • Checklists for QA Managers & Team Leads
  • Tutorials
    • Tutorials: HP QTP / UFT
    • Tutorials: HP LoadRunner
    • Tutorials: IBM Rational Functional Tester
  • Quizes
    • HP QC Expert Level Quiz
    • QTP Basic Level Quiz
    • QTP Intermediate Level Quiz
    • QTP Expert Level Quiz
    • RFT - Rational Functional Tester Quiz
    • Software Testing Basics Quiz
    • ISTQB Certification Quiz
    • CSTE Certification Quiz
  • Free eBooks
    • eBooks: HP QTP/UFT
    • eBooks: Manual Testing
Home > Knowledge Center > Flamboyant Topics > Database Testing > Why should we test a Relational Database

Why should we test a Relational Database

Sign up to receive Regular updates via email or RSS!

Type your email address and press Enter

Download Free eBooks

Download Several World-Class eBooks on "Software Testing" and "Quality Assurance" Absolutely Free of Cost!!!


Quick Links

  • Free Updates
  • Write & Earn
  • Quick Navigation Sitemap
  • ISTQB Certification
  • QTP Certifications

Advertisements

Why should we test a Relational Database

Posted in: Leave a comment

Why should we test a Relational Database

First of all let us quickly understand as to what are the Relational Datatbases

Relational databases are tabular databases that are used to store target related data that can be easily reorganized and queried. They are used in many applications by millions of end users.

What are the key aspects of Database Testing?

1) Testing of the actual data.

2) Database integrity.

3) Functionality testing of database application.

The users may access, update, delete or append to the database. The modified database should be error free. To make the database error free and to deliver the quality product, regression testing of the database must be done. Regression testing involves retesting of database again and again to ensure that it is free of all errors.

It is a relatively new  idea in the data community. Agile software developers take this approach to the application code.
Why should we test a RDBMS?

Extensive testing of RDBMS is done due to the following reasons:

1) Quality data is an important asset:According to a survey on the importance of quality data following conclusions were drawn:

a) 95.7% of people believed that data is a corporate asset.

b) 4.3% believed that data is not a corporate asset.

c) Out of the 95.7%, 40.3% had a test suite for data validation.

d) 31.6% discussed the importance of data.

2) Target related business functions are implemented in RDBMS: RDBMS should focus on mission-critical business functionality.

3) Present approaches of RDBMS testing are inefficient: Presently we develop a database by setting up database, write code to access the database, run code, and do SELECT operation to find the query results. Although visual inspection is a good start, it may help us to find problems but not prevent them.

4) Testing provides a concrete test suite to regression test an RDBMS: Database regression testing is the act of running the database test suite on a regular basis. This includes testing of actual data, database integrity, ensuring that database is not corrupted, schemas are correct as well as the functionality testing of database applications.

5) Verification of all modifications: Making changes to the database, may result in some serious errors like missing-data and regression testing may help us in detecting such missing – data.

What should be Tested in Relational Database?

Here we will be discussing both Black Box and White Box testing approaches on relational databases.

Black Box Testing involves the following:

1) I/O Validation: Regression testing will help us in validating incoming data-values; outgoing data -values from queues, stored- functions and views.

2) Error Handling: Regression testing of an RDBMS allows us to test quasi-nulls that is, empty strings are not allowed.

3) Validating Table Structure: We can validate the relationships between the rows in different tables. This is known as referential integrity. For example: if a row in an employee table references a row within the position table then that row should actually exist.

4) Testing interaction between SQL and other components such as scripts: Regression testing allows testing of interfaces between SQL and scripts by techniques such as parameter passing.

5) Testing of stored data: Data stored in the form of tables can be tested extensively by regression testing.

6) Testing of modified data: Updating the tables might introduce new errors which can be easily detected by regression testing.

White Box testing involves the following:

1) Testing of the entire structure of stored procedures and functions: Entire schema can be tested by regression testing. We can refactor our database tables into structures, which are more performant. The process of refactoring here means a small change to a database schema, which improves its design without changing its semantics. It is an evolutionary improvement of our database schema, which will support three things:

a) New needs of our customers.

b) Evolutionary software development.

c) Fix legacy database design problems.


2) Testing various stimulations:
 Regression testing allows unit testing of stored procedures, functions and triggers. The idea is that the testis automatically run via a test framework and success or failure is indicated via a Boolean flag.


3) Testing all views:
 Regression testing allows an extensive testing of all the three views viz, conceptual, logical and physical.

4) Testing of all data constraints: Regression testing allows testing of all data constraints like null values, handling single quote in a string field, handling comma in an integer field, handling wrong data types, large size value, large size string etc.

5) Improving the quality of data: Data quality may range from syntactic mistakes to undetectable dirty data. Data quality involves four C’s i.e., Correctness, Completeness, Comprehension and Consistency.


Correctness of Database:
 Regression testing provides a correct database by removing the following errors

a) Incorrect manipulation through the use of views.

b) Incorrect joins performed using non-key attributes.

c) Integrity constraints incorrectly used.

d) CHECK, UNIQUE and NULL constraints, which cause problems with data insertion, updations and deletions.

Many More Articles & Tutorials on Databse Testing

Posted in Database Testing, Flamboyant Topics

Post navigation

Tutorial-2 To Generate BVA Test Cases-For the Triangle Problem
When should we test a Database
Quick Links to Our Knowledgebase
Interview Preparation
Interview Preparation Resources for Beginners to Experts
PMI PMP (Project Management Professional) Certification
PMI PMP Certification Préparation Ressources
PMI PMP Certification Exam Practice Question Papers
Study Material for ISTQB Certifications
Study Material - ISTQB Certified Tester Foundation Level Exam
Study Material - ISTQB Agile Tester Extension Level Exam
Study Material - ISTQB Certified Tester Advanced Level - All 3 Certifications
Keep track of latest posts by subscribing our RSS feed.You can also Subscribe by E-mail and get All New articles delivered directly to your Inbox.
Study Material for CSTE Certification
Complete Study Material-Certified Software Test Engineer-CSTE Certification Exam
Certifications on Reputed Automation Tools
Study Material - HP QTP / UFT Certification Exam
Study Material - HP QC / ALM Certification Exam
Study Material - HP LoadRunner Certification Exam
Study Material - IBM Rational Functional Tester - RFT Certification Exam
Quick Navigation Sitemap of SoftwareTestingGenius

Get your Absolutely Free Copy of Several Presentations & E-Books related to ISTQB, HP QTP/UFT, Load Runner, RFT and many more Certification Exams, prepared by Expert & Trainers, by writing to: Software.testing.genius@gmail.com

Share Your Views Cancel reply

Your email address will not be published. Required fields are marked *

Advertisements

  • Popular
  • Recent
Full Study Material for ISTQB-Foundation to All 3 Advanced level Certification Exams
Consolidated Study Material-Full Knowledgebase on QA and Testing
Consolidated Study Material-IBM RFT Certification Exam
Consolidated Study Material-QTP and QC Certification Exams
Consolidated Study Material-ISTQB Certification Exams
An Insight to Project Management – A Short Primer for Novice to Experts
Essential Skills an Effective Project Manager must have
Determine whether a given endeavor is a Project? or not?
Glossary of terms related to Project Management-Alphabet T to Z
Glossary of terms related to Project Management-Alphabet Q to S

About Us
Know more about Software Testing Genius!
Contact Us
Start a conversation with our team of experts!
Easy Navigation Sitemap
Quickly navigate through Software Testing Genius!

Privacy Policy
Copyright Policy
Online Conduct

Advertise
Promote your Website, Product or Services!
QTP/UFT Training
Get Online Training From HP Certified Experts!
Software Testing Service
Outsource your testing requirements to us!
Connect with us
Latest Posts
  • An Insight to Project Management – A Short Primer for Novice to Experts
  • New Techniques emerging out of the Fourth Industrial Revolution
  • What is Katalon Studio and How to Use it
  • Quick Start to preparation for ISTQB Agile Tester Extension Exam
  • An insight to the revolution of “Big Data” – A Primer

Free & Best Study Material

  • ISTQB Certification Foundation & Advanced
  • QTP Certification (UFT 11.5) & ALM
  • HP Load Runner 12.x
  • IBM Rational Functional Tester (000-842)

Copyscape Protection

Copyright © 2008 - 2019 Software Testing Genius

Web Cohort: Corporate Network Executions