What is Database Testing? How will you do it?

Answers were Sorted based on User's Feedback



What is Database Testing? How will you do it?..

Answer / rajendra prasad reddy penumall

sorry sudeep your answer is wrong DATA DRIVEN TESTING is
nothing but restesting the application with different types
of inputs.

BUT database testing is different.

here the database testing means the data entered in the
front end should store properly and the data stored in the
backend(database like SQL server,Oracle..)should be display
in front end properly without any change.

here the data stored in the backend in the form of tables.

for eample if we take yahoomail login page for signin
the frontend the login window askes you your UserID and
password.

the user ID and password will be compared with the databse
table values which you entered at the time of new account
registration.

So here there is a big diffrenece bet ween database testing
and Data Driven testing.

Database testing is testing of data consistemcy in the
database

Is This Answer Correct ?    19 Yes 1 No

What is Database Testing? How will you do it?..

Answer / guest

Database testing is nothing but testing the mapping between
front and back end.
Ex:When an user details is entered in front end, then the
details should be confirmed in the database whether the
entered details are properly inserted in the corresponding
table(s).

Is This Answer Correct ?    11 Yes 3 No

What is Database Testing? How will you do it?..

Answer / ajit kumar lal

Database testing means any/all of following as per the
application:

1. Ensuring the Data validity: requires SQL queries to
validate the same
2. Ensuring the Data integrity: requires various
constraints (both IO and Buisiness) to check
3. Ensuring the performance of database operations
especially in case if accessing Views and Indexes: Various
tools are available to check the same especially Database
Refactoring. You can also your Database sandbox on the fly
and use TFD or TDD approach to test the same
4. Ensuring the performance of Database when using
Functions, Cursors, trigers etc.

I hope above is clear to all of you......

Is This Answer Correct ?    7 Yes 0 No

What is Database Testing? How will you do it?..

Answer / prasant

I agree with Rajendra Prasad Reddy Penumall's answer

Is This Answer Correct ?    3 Yes 0 No

What is Database Testing? How will you do it?..

Answer / ajit kumar lal

All of you are correct to some extent and not
fully....Please refer to my last answer to databse testing
fpr full fledged answer....

-Ajit

Is This Answer Correct ?    2 Yes 0 No

What is Database Testing? How will you do it?..

Answer / raam

Ajith Kumar Lal has given proper answer, i mean some in
depth answer. better to follow his answer.

Is This Answer Correct ?    1 Yes 0 No

What is Database Testing? How will you do it?..

Answer / sridhar

Database Testing means To test the Appilication from Back
End,Insert,update and delete data from back end and select
same data from front end then compare the information

Ex: Enter Employee information from front End,and update
date the information from back end,select the person front
End,not only for single useful for multiple

Is This Answer Correct ?    0 Yes 0 No

What is Database Testing? How will you do it?..

Answer / manoj

Actually the database Testing is the testing of data which
should be same as in case of backend as well as front end
this is somewhat at the level of aplication but testing of
database at stand alone database application is vry much
different concept as it implements the concept of database
design the tests are suppose to be carried out at the
design level of database,how the data should stored in
database etc. I hope this clear the difference between
database testing at application level and standalone
database application

Regds
Manoj
manoj.raut1@indiatimes.com

Is This Answer Correct ?    0 Yes 0 No

What is Database Testing? How will you do it?..

Answer / kamalasan.baireddy

Data badse testing is testing the consistence of
data.Whether input data is stored correctly in database or
not?and checking the tables?

Data Driven testing is retesting the same application with
different inputs.

EX:

Any login page talkes inputs as id and passwd.

Data base testing: Checking wheather id and password fileds
are stored in table or not and etc..

Datadriven testing:checking the same page with different
inputs (nothing but regression)

Is This Answer Correct ?    0 Yes 0 No

What is Database Testing? How will you do it?..

Answer / sudip

database testing is a testing with multipale database.often
called datadriven testing .we can do it by using mercury's
winrunner automation tool.open winrunner , and open testing
application.......create test screipt ........add develop
loop by selecting the text screipt from that point from
where u want to make loop for data driven after selecting
it go to tools and select datadriven wizard click next
first.. follow the prompt and select creat defult data file
to creat xls file. go to xls data sheet and put what ever
data u want to derive for test. close it make sure Gui map
is loded cheak once and run it.

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More QA Concepts Interview Questions

What is quality audit?

0 Answers  


disadvantages of V-Model in Software Testing?

1 Answers  


What is 'Context Driven Testing' in Agile Method?

3 Answers   L&T,


What are the challenges faced with the 1+ years experience team.

0 Answers   Bharat Petroleum,


what is the difference between SDLC and SQA life cycle?

4 Answers  






how do i know that I am using 32 bit Windows

5 Answers   SunGard,


At wht stage in the SDLC testing should be started?

4 Answers   IBM,


What is cyclomatic complexity?

4 Answers   ISTQB,


How would you test an ATM Machine?

4 Answers  


please answer the difference between QA & QC with practical example

5 Answers   Protech,


how will you define your bug status flow in softsmith qamonitor?

1 Answers  


What is difference between Six Sigma and CMMI and how both relate/differ to each other

1 Answers  


Categories