Top 10 Manual Testing Interview Questions

1. Explain Defect Life cycle

2. Different Functional testing techniques

3. Different testing methodologies

4. Why do we do negative testing?

5. The scenario of conflict where the developer doesn't agree that a bug is a bug

6. Explain Agile testing methodology

7. How do we link requirements, test plan, test case and defects in Quality Center or Test Director

8. What is the difference between Test Approach, Strategy and Plan

9. Explain some important QA processes

10. The scenario of playing smart where you have less time and more work

Database Migration Testing

Why Database Migration?

Database Migration in Investment Banks or any other place is done for the improvement of technology leading to a better performance. For example the same query fired on Sybase 15 database would take lesser time as compared to Sybase 12. The database migration can be between different versions of the same database for example Oracle 9i to Oracle 10g or migration to a different type of Database example Sybase to Oracle.

Test Approach for Database Migration Testing

The test approach for database testing is very crucial since in any investment bank the data is of utmost importance. If data is not migrated properly on the new database then the results could be disastrous. Hence, it is very important to use an approach which takes care of the existing data being migrated smoothly and the new data can be created like it was before migration.

Also, it is very important that the existing functionalities of the application do not change after the migration. So, the regression phase in database migration is also very important. If the migration is from one version of the database to another version of the same database, then running a sanity pack is enough generally but if the migration is to a different kind of database then running a regression pack is inevitable.

It is always advisable to do the database migration in parts in the following cases

• When the database is huge
• When the database migration is to a different type of database

The testing approach for Functional testing should take care of the following steps-

• Before the developers run the build for database migration, extract the data which is already present on the older database with all the details and verify the data after the database has been migrated
• After the database has been migrate, create the same sort of data that you were able to successfully create before the database migration
• Also try operations like amending and deletion after the database has been migrated on the new and old data.
• Also, try to perform all the operations which involves querying database