GeekInterview.com
Series: Subject: Topic:
Question: 59 of 60

What is Database testing?

Asked by: Interview Candidate | Asked on: Sep 10th, 2005
Showing Answers 1 - 30 of 30 Answers
KotiReddy

Answered On : Jun 28th, 2005

Here database testing means test engineer should test the data integrity, data accessing,query retriving,modifications,updation and deletion etc

  
Login to rate this answer.
malinibandi

Answered On : Jul 14th, 2005

  
Login to rate this answer.
SURESH SONDUR

Answered On : Aug 25th, 2005

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. 

Yes  4 Users have rated as useful.
  
Login to rate this answer.
meena

Answered On : Sep 10th, 2005

To test the values retrieving from database by the application are corrctly matching with the information stored in original database.

Yes  1 User has rated as useful.
  
Login to rate this answer.
suguresh

Answered On : Sep 30th, 2005

HI I think that the above answer is not correct?

  
Login to rate this answer.
kishor

Answered On : Oct 4th, 2005

Data base testing generally deals with the follwoing:a)Checking the integrity of UI data with Database Datab)Checking whether any junk data is displaying in UI other than that stored in Databasec)Checking execution of stored procedures with the input values taken from the database tablesd)Checking the Data Migration .e)Execution of jobs if anyPlease correct me if I am wrong:Thanks.Kishore

Yes  2 Users have rated as useful.
  
Login to rate this answer.
prathiba

Answered On : Nov 7th, 2005

Suguresh Wrote: HI I think that the above answer is not correct?Then what is the answer?

  
Login to rate this answer.
sandy28

Answered On : Nov 8th, 2005

View all answers by sandy28

Pl reply immediately.

  
Login to rate this answer.
sandy28

Answered On : Nov 8th, 2005

View all answers by sandy28

How to execute a sql query in winrunner? pl reply immediately

  
Login to rate this answer.
prasad

Answered On : Nov 30th, 2005

Testing the backend data bases like comparing  the actual results  with expected results.

  
Login to rate this answer.
sridharnag

Answered On : Dec 5th, 2005

View all answers by sridharnag

Step1. Create a DSN for the data base.db_connect("dsnname","connection string");db_execute_Queary("session id","SQL Statement",outvariable);db_disconnect("session id");

  
Login to rate this answer.
venkatn

Answered On : Dec 27th, 2005

Database testing :What ever the input we give in the client side ,we will be verify the that .how it's refelected in the database .is it going into the correct table .it's verification of datawhich every we give in the client side

  
Login to rate this answer.
S.AJAY

Answered On : Jan 2nd, 2006

DEAR FRIEND,          ACTUALLY IN WIN RUNNER,QUERY ANALYZER OPTION IS AVAILABLE FOR EXECUTE SQL QUERY

  
Login to rate this answer.
S.AJAY

Answered On : Jan 2nd, 2006

DEAR FRIEND,          ACTUALLY IN WIN RUNNER,QUERY ANALYZER OPTION IS AVAILABLE FOR EXECUTE SQL QUERY

  
Login to rate this answer.
swamy

Answered On : Jan 5th, 2006

Hithis is swamyby using data base check points(spcify sql statement) ordb_connect("query",...........);

  
Login to rate this answer.
Majid

Answered On : May 1st, 2006

  
Login to rate this answer.

The exact process is1) connect to the databasedb_connect("query1",DRIVER={drivername};SERVER=server_name;UID=uidname;PWD=password;DBQ=database_name ");2)Execute the querydb_excecute_query("query1","write query u want to execute");-Condition to be mentioned-3)disconnect the connectiondb_disconnect("query"); Don't hesitate to ask me questions. ThanksSivaiahCognizant Bangalore

  
Login to rate this answer.
sujeesh krishnan

Answered On : Jul 29th, 2006

By using MS Query in winrunner we can  execute SQL

  
Login to rate this answer.
Parvathi

Answered On : Nov 8th, 2006

Hi,Basically in Database testing to check,1.Data integritity and validaty testing.2.Any strored procedure written.3.Execution of Triggers and constraints.4.In WIN RUNNER,Query Analyzer Option is Available For Execute SQL Query.Thanks,Parvathi.

  
Login to rate this answer.

Actually when we talk about Database, we consider DDL and DML.DDL is data defination language. and DML is data manipulation language.When we do database testing we will use DML to test database. Anything we can done using DML we will do in database testing.

  
Login to rate this answer.
praveen kumar

Answered On : Jan 9th, 2007

Hi,    In database testing we test the impact of front end operation on backend tables.

  
Login to rate this answer.

  
Login to rate this answer.
Khajam

Answered On : Jun 11th, 2007

View all answers by Khajam

Hi All,According to my Knoweldge Database testing: This can be explained in two perspective           1. Checking  the front end Application with the backend data by using Queries in the backend such as SELECT , INSERT , UPDATE , DELETE..For example: For login Page you have to check whether the user id and Password exists in the database and then only the user is capable to login to the home page        Select * from where User_name ='abab' and Pswd='ghjh**';Likewise checking the front end Application corresponding to backend..                     2. Database Testing: It represents testing whether you are able to create tables, triggers, stored procedures, constraints, Indexes in the database and testing the performance of database.My question is Whether a tester without the knoweldge of front end like JAVA.. Can test the Webapplication according to the backend?  Thanks

  
Login to rate this answer.
Shailesh

Answered On : Jun 17th, 2007

Basically database testing related to front end to back end data migrating and intigrety. we have to check whatever insert, delete and update from front end and what effect on back end. Any editable field on fornt end but not update in back end so we have to check every data from front to back. It any query than revert back.Thanks,Shailesh

  
Login to rate this answer.
P.Ranjith Kumar

Answered On : Aug 26th, 2007

Database testing involves mainly 1. When a record is inserted in the front end checking whether the record is inserted in the corresponding tables correctly in the back-end.2. Whether the field size validations are done according to the requirements in front-end as well as back end.3. Testing the performance of the stored procedures.This is done by calculating the time taken to execute the stored procedure.4. Primary key,foreign key validations are done correctly.

  
Login to rate this answer.

Database testing means we can integrate data,retrive data,inserting data,delete data in according with the custometer requirement(business logic).

  
Login to rate this answer.
mskazad

Answered On : Jun 25th, 2011

View all answers by mskazad

Database testing means test engineer should test the data integrity, data accessing, query retrieving,modifications, updating and deleting etc

  
Login to rate this answer.

Hi
Database testing mainly checks three things while testing :

1)Addition/Update data : In this scenario we are checking weather we the data is updated or added to the database when we do any modification in the front end.

2)Deletion :In this scenario we are checking weather the is deleted in the database when we do any deletion in the front end. Note : In most of the case the data in the DB is not deleted instead it changes a specific column (like ROW_STATUS)from 1 to 0. To avoid risk if need of future use of the same.

3)Retrieve : In this scenario we check weather the data in the DB is retrieved when we ask for in the front end.It checks for the section of data from the DB .

Note : DB testing manually indulge use of Query.

  
Login to rate this answer.
Pawan Kumar Singh

Answered On : Jun 5th, 2012

Database testing involves the tests to check the exact values which have been retrieved from the database by the web or desktop application. Data should be matched correctly as per the records are stored in the database.

  
Login to rate this answer.
kritee

Answered On : Sep 26th, 2014

Database testing is nothing but impact on db with respect to impact on front end users operation.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.