Trainee Tester Interview Questions and Answers

Critical defects encountered during testing and how they were identified

• Critical defects are those that can cause system failure or data loss

• Examples include security vulnerabilities, data corruption, and system crashes

• Defects can be identified through manual testing, automated testing, or user feedback

• Defects should be documented and reported to the development team for resolution

Intersect returns common rows between two tables while Inner Join returns matching rows based on a specified condition.

• Intersect returns only the common rows between two tables.

• Inner Join returns matching rows based on a specified condition.

• Intersect does not require a join condition.

• Inner Join requires a join condition to match rows.

• Intersect can be used with any data type.

• Inner Join is typically used with numeric or date data types.

• Example: SELECT * FROM Table1 INTERSECT SE...read more

ETL is required to extract, transform and load data from various sources into a target system.

• ETL helps to integrate data from multiple sources into a single system

• It ensures data accuracy, consistency and completeness

• ETL is used in data warehousing, business intelligence and analytics

• Examples of ETL tools include Informatica, Talend, and Microsoft SSIS