DataBase Testing Interview Questions

Code
SELECT lastname,salary FROM employee WHERE salary IN 
 (SELECT min(salary) FROM employee 
WHERE salary IN (SELECT TOP 2 SALARY  
FROM EMPLOYEE ORDER BY SALARY DESC))

Code
SELECT * FROM
   (SELECT population,ROW_NUMBER() OVER(ORDER BY population)Poporder FROM india)
   WHERE Poporder = 2;

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

select ename,dept,sal from emp group by ename having dept order by sal

The Transact-SQL commands most often used by a tester are:USE database_name SELECT column_names FROM table_nameSELECT DISTINCT column_name FROM table_name'SELECT column_name FROM table_name W...

Join: We can display data from two or more than two table using Join.

There are 4 Types of Join-
1) Natural Join
2) Inner Join
3) Outer Join
4) Cross Join

Outer Join is further divide into two types-
1) Left outer join
2) Right Outer Join

May I suggest internet?

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

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

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

u can extract data from different table using the joins in sql

using inner join
         outer join etc.

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

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 ssn_no, LENGTH(ssn_no) FROM Customer_Info

select ID from test where ID Between 9999 and 100000

you can try this out also.....

1. No of tables in both old and new should be same2. Table structures in both old and new should be same.3. If it's a Data nmigration to , then ned to compare the no of records in all the tables i...

We need to check out what was all the enhancement the SQL Server 2008 has in it.  We need to design our testcase considering the following points.1.      Data type used2....

Suppoe there is table called SOURCE, conatins column NAME and AGE.  The reuirement is that to poulate records from SOURCE to the target tale TARGET. In TARGET table contain following co...

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

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

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

Data migration is translation of data in the tables from one db to another or is can also be from one format to another format.Checks needed are,Need to identify the source table in source db & de...

Data migration testing is to compare migrated data with original data to find out any discrepancies. Database Migration Testing: 1. We have to check database integrity. 2. We have to check the referen...

Testing a database can involve a combination of black-box testing and validation of the database using queries.  One example would be to verify whether data is beling properly validated and then ...

I think database testing evolves the testing of the data that we retrieve from database by writting queries. So to implement the database one must be proficient with writting queries.Another point is ...

SELECT column_names FROM table_nameSELECT DISTINCT column_name FROM table_nameSELECT column_name FROM table_name WHERE conditionSELECT column_name FROM table_name WHERE condition1 AND condition2SELECT...

1. Select * from <Table Name>  ---> It will select all rows from the table.2. Select <Column Name1>, <Column Name2 from <Table Name> ---> It will select all rows of col...