how we can do Assess data for timeliness, consistency, accuracy

Describe your experience using tools like SQL to query into the underlying data to investigate test issues that have arisen, requiring bulk data to be pulled out of source systems and analysed?

Describe the experience you have had with "hands-on" testing, focusing particularly on where this has been testing of management information, including data migration work?

Harry

• Apr 24th, 2006

Data Integrity checks should be performed.  IF the database schema is 3rd normal form, then that should be maintained.  Check to see if any of the constraints have thrown an error.  The...

Answer Question  Select Best Answer

How would you check the database integrity testing through SQL?

geocityco

• Nov 28th, 2011

Check database integrity Check the allocation and structural integrity of user and system tables, and indexes in the database, by running the DBCC CHECKDB Transact-SQL statement. This ensures that a...

Answer Question  Select Best Answer

siriatwork

 Profile Answers by siriatwork Questions by siriatwork

• Dec 27th, 2007

Good Question! Normally one doesn't keep in mind that the documentation guidelines for database testing should be more and more detailed. - The tester should know how to log on to the databas...

Answer Question  Select Best Answer

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Apr 25th, 2006

in QTP we r writing queries for fetching the values.1.when u r using database checkpoint then u have to write the sql statement.2.when u r fetch the values from the database then also u have to write the sql statement.

saami

• Feb 8th, 2006

in QTPusing output databse check point and  database check point ,select sQL manual queries option and enter the "select" queris to retrive data in the database  and compare  the expected and actual

Answer Question  Select Best Answer

nstylish

 Profile Answers by nstylish Questions by nstylish

• Mar 17th, 2008

Well DTS which we call it as a data transformation service will be used only for the insertion i believe other than delete and update, specially during transformation from text file (source) to the ...

Answer Question  Select Best Answer

Bheem

• Jan 17th, 2007

Always Database is the back end and application will be the front end so u have to login to Oracle Database then measure the total no. of records related to that application flow.If it is web applicat...

Answer Question  Select Best Answer

Amit Bansal

• May 9th, 2007

To check the correctness of SP you should have a good knowledge to understand SP(Stored Procedure). You have to understand what are the steps and what about the expected resul...

Answer Question  Select Best Answer

Guest

• Jan 5th, 2007

The following has to be taken into considerationCorrectness of Data:1. Check whether default values are set for the necessary fields2. Check whether for the integrity constraints3. Check whether the v...

Answer Question  Select Best Answer

How are ORACLEs AIM (Application Implementation Methodology) used in testing?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Mar 13th, 2012

During testing oracles amis at Business System Testing which focuses on linking test requirements back to business requirements and securing project resources needed for testing. It supports utilizin...

Answer Question  Select Best Answer

What are the basic things you test in database testing?

Sharad_Noida

 Profile Answers by Sharad_Noida Questions by Sharad_Noida

• Jun 8th, 2010

In DB Testing we validate the proper data is maintained at Backend. We also validate the Stored Procedure return the expected result. And we also perform the Data migration migration means upgrade testing on DB like upgrade DB from SQL 2005 to SQL 2008....

Answer Question  Select Best Answer

How do you do back end testing?

prashantmunjewar

 Profile Answers by prashantmunjewar Questions by prashantmunjewar

• Dec 16th, 2010

Cross Verify the front end changes reflection in case of Add, update and Delete operatiomn of any field.it confirms that your changes made by application saves successfully

Answer Question  Select Best Answer

Accy test

• Nov 28th, 2014

Well, in order to test report generating after successful execution of job,you need to perform following tests: 1. Verify the report is generated at the respective path or not. 2. Verify the format/...

Answer Question  Select Best Answer

What are the exact roles and responsibilities of a database tester?

Bina Sarmah

• Nov 15th, 2012

To conduct database testing the test engineers are following bellow issues:
1) Verification of data entered by the users through application at back end.
2) Verification of database design
3) Verifying the data integrity
4) Verification of SQL scripts.

Answer Question  Select Best Answer

stephen

• Oct 23rd, 2006

Yes. since i know that we may not calculate the apt micro  sec and all but still if the quality of s/w is justified bad because of the slow processing of the data, then it is. Normally we dont fi...

Ashish Nainwal

• Jul 24th, 2006

No. I do not think so. Since the requirement seems to be ambiguous. The SRS should clearly mention the performance or transaction requirements i.e. It should say like 'A DB retrival rate of 5 micro sec'.

Answer Question  Select Best Answer

archus

 Profile Answers by archus Questions by archus

• Jun 26th, 2009

We can use connection object class to establish connection to the specified DB during runtime set ConObj=CreateObject("ADODB.Connection") ConObj.Open"Provider = Provider Name"...

Raman

• Nov 5th, 2007

You can use ADO's(ActiveX Data Objects)?for connecting database from applications.If u are new to ADO and want to learn?refer the following URLhttp://msdn2.microsoft.com/en-us/library/ms807730.aspx?

Answer Question  Select Best Answer