What is the database testing?

Question

Thank you!! ^^

Answer 1

I never heard abt database testing

i learnt

1)Load testing

2)Recurssion testing

i think u r abt Load testing,is it a testing when many virtual users fetch data from a database at same time,then what load is prepared on database

Answer 2

Database testing is to test database performances when it is access by many users at the same time.

If these users query for huge amount of data and the database do not have enough resources. The database will crash and the data wil be corrupted.

The database administrator will base on the test to decide whether to add more RAM or hard disks to the database server to handle the work load.

Answer 3

Database testing is either:

Testing the parts of an application that access a database - for example, if I have a sales program which interacts with a database of customers, I might test things like "Add new customer" or "Change customer contact details".

Alternatively, database testing may involve testing the actual database - for example, ensuring that primary/foreign keys & constraints are correct. I might have a database where I want to store product information, so I should check that it's impossible to create a product with a negative price, or have two products with the same name.

Answer 4

Data bas testing basically include the following.

1)Data validity testing.

2)Data Integritity testing

3)Performance related to data base.

4)Testing of Procedure,triggers and functions.



for doing data validity testing you should be good in SQL queries

For data integrity testing you should know about referintial integrity and different constraint.

For performance related things you should have idea about the table structure and design.

for testing Procedure triggers and functions you should be able to understand the same.