Senthilvel

Jan 19th, 2015

Data base Migration testing is done with the help of the Mapping document that defines the complete mapping from the source to the target and also the transformation logic that has to be applied while...

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/...

How will you verify that there are no social security numbers greater than or less than 9 digits long in a table called customer_info?
Write the SQL query that will identify any social security numbers that do not meet this criteria

kritee

Sep 26th, 2014

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

Pawan Kumar Singh

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.

How will you check data redundancy and data consistency using SQL queries?

sandesh mastake

Apr 23rd, 2013

Data redundancy means youre checking for duplication. In order to make that check, you need to determine what signifies a duplicate within the table to which you are referring. There is not a single q...

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.

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...

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...

@ 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...

Ok lets do this by taking an example.
Lets say you are testing the integration between database and a user registration web application. User registration web site becomes your front-end and database...

govind kumar

Aug 9th, 2011

For writing test cases in Database first one should define the project name, then module,Bug number,objective,steps/action undertaken,expected result,actual result, then status, priority and severity.

Select * from EMP where EMP_DOJ = 010110Here EMP is the Table name,EMP_DOJ is the date of joining of the Employee in EMP table.If any record/records found with DOJ as 010110,it will retrive all the re...

Database Testing deals with the following:-1) Testing the data in the Database for Feed/Flat File data based on the requirements by writing medium to complex queries using SELECT, INNER JOINS/OUTER JO...

Rajani

May 8th, 2007

Hi Raghu,The answer you gave is very useful,. but can you be a bit more elaborative as of to what extent do we need to work with indexes, cursors and how to test a SP with some examples if possible!!Thanks Rajani

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....

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.