-
-
Database Testing
How would you check the database integrity testing through SQL?
-
What are the steps that must be included in testing guideline document for database testing?
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...
-
How to use sql queries in WinRunner/QTP
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
-
How to test a DTS package created for data insert update and delete? What should be considered in the above case while testing it?What conditions are to be checked if the data is inserted, updated or deleted using a text files?
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 ...
-
-
-
-
ORACLEs AIM
How are ORACLEs AIM (Application Implementation Methodology) used in testing?
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...
-
Basic Database Testing
What are the basic things you test in database testing?
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....
-
What is your approach to do back endtesting?
How do you do back end testing?
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
-
-
Database testing roles and responsibilities
What are the exact roles and responsibilities of a database tester?
-
-
How do you connect to the database from application?
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?
-
Database Testing
How to test Back end testing for web portal application? What all the main things must be consider?Pls give detail documents?Database testing or Backend Testing is same
Jyothi_E
- Jun 6th, 2007
Database testing and backend testing are same.In this type of testing testers need to have the knowledge on front end application and the backend database schema.When the field values are inserted thr...
lavanyamk2000
- Mar 26th, 2007
Back end testing and Database testing both are same.For testing Web portal we have to be clear with requirement and mapping documents.Do transactions through Web portal and check in backend whether the changes are reflected or not.
-
How to extract data from different datasource
( For e.g You have databases Oracle, Sql Server 2000 etc and one of the table (columns) is unique in both the databases)?
mithr17
- Nov 23rd, 2011
@ dugulam: I would have agreed with your answer if both the databases were of the same type. Meaning if both the DBs were Oracle or both were SQL Server. But, the example in the question involved diff...
dugulam
- Apr 10th, 2011
U can extract data from different table using the joins in sqlusing inner join outer join etc.
-
How to verify build instructions.Mention steps.
idreams27
- Jul 6th, 2007
Hi,Usually you will be provided with build instructions manual( which contians sequence of steps how to proceed with your build deployment) as part of Test Execution phase. This is one important point...
hanumanth mulimani
- Nov 16th, 2006
Hi, Nice question But i think it depends on the projects to projects.Best is if it has some somke test cases that will work out There may be many builds in one day, so some time u may not even have ti...
-
How can we test the correctness of data in our report with database(oracle) in our application when user do not have any knowledge about database testing or sql queries?
kurtz182
- Jan 10th, 2010
The answer to this question depends on what is meant by the term "correctness of data". A tester can often test the correctness of data type and constraints on the data by reviewing the application's technical specifications.
sriramkalli
- Oct 3rd, 2007
if the Users are using any Reporting tool like Business Objects they can test the correcness of the data with the report generated in Oracle.They dont need to know any sql if they use business objects tool .
-
DataBase Testing Interview Questions
Ans