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 r the defect status for bugs

2 Answers   Oracle,


where can i can get QTP real time projects and process?

2 Answers  


What is test oracle in testing? Why it is using? What is the advantage when a test oracle is used?

1 Answers  


What and where are the policy statements that dictate quality assurance in your project?

1 Answers  


Software Quality Assurance Progress: Scenario I. Defining SQA milestones II. Assigning SQA resources III. SQA scheduling IV. SQA budgeting V. Selecting software development tools that will interface with the SQA tools VI. Reviewing any contracts with subcontractors for SQA requirements In the above statements, which of the tasks are included in planning the overall SQA effort? Choice 1 I, III, V, and VI Choice 2 I, II, III, and IV Choice 3 I, II, III, and V Choice 4 III, IV, V, and VI Choice 5 II, III, V, and VI

2 Answers   Brainbench Certification,






Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.

0 Answers   NTT Data,


What is User Acceptance testing?

7 Answers   Ordain Solutions,


hi, i am recently joining a SW house as a QA but i have no any experirnce in it so i need some help to solve this my question is that what is the staring steps to make the test plan of web application and also how make the test case

2 Answers  


Have you used any automation tools?

0 Answers  


What are The Main Sources of Software Bugs

2 Answers  


what is the difference bet., MYSQL and ORACLE

3 Answers   Oracle,


What is Release Note and its contents?

4 Answers  


Categories