QA Testing - What is the Database Verification? What type of information would you look at in the Database?

GeekInterview.com > Interview Questions > Testing > QA Testing

Go To First | Previous Question | Next Question

QA Testing | Question 112 of 176

What is the Database Verification? What type of information would you look at in the Database?

Total Answers and Comments: 4

Last Update: December 27, 2007 Asked by: irinak

Sponsored Links

Best Rated Answer

—

Submitted by: ferrarigf

Database verification is a process of testing the database. In which you run some queries to see if the data has been processed correctly or not. For example: Say that you purchased a dell laptop, you submit all your information like Last name, First name, Address and some more details of yours to the dell customer service. But actually in the backend your information is going into the dell database.

So now as a part of QAtesting we do database verfication i.e., run some queries (SQL) to look up data in the database.

Above answer was rated as good by the following members:
Ritik1008

November 22, 2007 05:53:10

siddu

RE: What is the Database Verification? What type of in...

When we are testing an Application we may enter some inputs. We have to check whether the inputs are stored in the Database or not. Ex: if you store any Person details and save when you login next time those details should be shown in DB. So verifiying DB we cal as DB testing.
What information we have to check is Execute the table and check first the values had fall into the Table or not. 2ndly we check character size. (ex: in front application we give 30 char and DB accepts only upto 25 characters. means it will be an Issue)

This way we test DB as per our requirements needed for the application.

Is this answer useful? Yes | No

November 29, 2007 23:21:23

ferrarigf

Member Since: November 2007 Contribution: 4

RE: What is the Database Verification? What type of information would you look at in the Database?

Database verification is a process of testing the database. In which you run some queries to see if the data has been processed correctly or not. For example: Say that you purchased a dell laptop you submit all your information like Last name First name Address and some more details of yours to the dell customer service. But actually in the backend your information is going into the dell database.

So now as a part of QAtesting we do database verfication i.e. run some queries (SQL) to look up data in the database.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 09, 2007 21:05:07

gettoknow

Member Since: November 2007 Contribution: 24

RE: What is the Database Verification? What type of information would you look at in the Database?

The information that is entered in the front end shd be saved in the (backend)database as database is the placeholder of data.
In database verification we check for data validity(by executing sql queries)
data intergrity( by checking for refrential intergrity and constraints)
performance of the server
and verifying stored procedures and triggers and its functions

for eg in online shopping webapplication
whenever an item is ordered online then the data in the backend at the ordertable shd be updated and the itenaryitem table shd be correspondingly updated reflecting in the decrease of an item.

Is this answer useful? Yes | No

December 27, 2007 10:27:25

Pawi_lp

Member Since: December 2007 Contribution: 2

RE: What is the Database Verification? What type of information would you look at in the Database?

Verify that all information is being entered correctly. Sometimes on international programs there are problems with dates format.
Then nother big point to test is to see the reference problems sometimes a user is able to enter for example a zip code without a city related to it and it may cause a reference problem.
Test updates and deletes to see if unnecesary data is being removed. Sometimes an action saves to much information and never deletes it with the time the DB will grow.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank