Database Testing

Question 1

Long-term data storage

Answer 1

What’s database where data is stored in tables in the forms of rows and columns

Question 2

Parts of a database

Answer 2

Data and Schema

Question 3

What’s data

Answer 3

Data is information

Question 4

What’s a table

Answer 4

Table is a set of rows and rows have columns

Question 5

Object and Properties

Answer 5

Another way of looking at rows and columns where the row is an object and column is a property

Question 6

What’s schema

Answer 6

Data structures - Tables, Rows, Columns, Datatype

Data structure in the Database is called schema

Question 7

What are the other parts of schema other than tables, rows and columns

Answer 7

Functions, Triggers, Views and Procedures

Question 8

What’s a view

Answer 8

Section of a database - show the data from a single table or multiple tables

Question 9

What’s a stored procedure

Answer 9

small program contain SQL queries - can accept inputs

Question 10

What is a function?

Answer 10

Function just has input parameter. Stored Procedure has both input and output parameters

Question 11

What is a trigger?

Answer 11

Small program that executes automatically when you perform an operation on a table

Question 12

What do you do in schema testing

Answer 12

check the column names and their datatypes and the number of characters it can take in and check the relationship between the tables (using the schema diagram)

Question 13

how do you test a view in a database?

Answer 13

x

Question 14

how do you test stored procedure?

Answer 14

x

Question 15

how do you test a function?

Answer 15

Getdate (), Square ()

Question 16

When do you perform the schema testing?

Answer 16

Schema testing is done when the database for first designed and created

Question 17

Where the major part of effort will go into testing the database. Schema or Data?

Answer 17

Data

Question 18

What we test in a table?

Answer 18

Check whether the data is captured correctly with respect to Source (xml file or another db or captured in form)

Question 19

Give me an example how do you write a Group By query?

Answer 19

TBD

Question 20

Give me an example of nested SQL query

Answer 20

TBD

Question 21

Database Testing Challenges

Answer 21

Large Size of the DB
Solution: Important and prioritize the data to be tested in important tables.

Frequent Changes to the DB schema

Question 22

What’s your database testing approach?

Answer 22

a) Gather the database testing requirements
b) Create test scenarios against each of those requirement. Test Schema and Data
c) Negative testing - Try inserting invalid data
d) Update existing valid data into invalid data
f) Try and delete a data where it shouldnt be deleted
g) Security testing in DB testing which involves privileges

Question 23

DB test plan components

Answer 23

DB name and application
Scope (in scope/out of scope)
Test approach (what are the test you are going to perform)
Test Environment, Server, Tool
Task and Schedule
Entry and Exit Criteria for testing
Defect Reporting
Risks/Mitigation

Question 24

What’s data quality or data issues

Answer 24

a) Incomplete or missing data
b) Inaccuracy
c) Inconsistency (for e.g. currency in dollar and euro)
d) Duplication or Redundancy
e) Non standard format data (for e.g. number of places after the decimal point)

Question 25

Data Profiling - Explore data, identify issues and summarize data
Data Cleansing - fix data issues
Data Monitoring - maintain data quality

Answer 25

Data Quality Assurance Process