IVS Software Solutions. Software Manual Tester Interview Questions and Answers

SQL join and other queries are used to retrieve data from multiple tables based on specified conditions.

• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use WHERE clause to specify conditions for the join

• Use GROUP BY to group rows that have the same values

• Use ORDER BY to sort the result set

Inner join is a type of join operation that returns only the rows that have matching values in both tables being joined.

• Inner join combines rows from two tables based on a related column between them

• It returns only the rows where there is a match between the columns in both tables

• If there is no match, the row is not included in the result set

The best technique to generate automated test report is to use a reporting tool that integrates with the automation framework.

• Choose a reporting tool that supports the programming language and automation framework being used

• Configure the reporting tool to generate reports in the desired format

• Include relevant information in the report such as test case name, status, and duration

• Add screenshots or videos to the report t...read more

Use Assertion methods to compare expected and actual results in Selenium.

• Use Assertion methods like assertEquals(), assertNotEquals(), assertTrue(), assertFalse(), etc.

• Pass the expected and actual results as parameters to the Assertion methods.

• If the expected and actual results match, the test case will pass, else it will fail.

• Example: assertEquals(expectedResult, actualResult);

The best technologies for building a good software testing framework are Selenium, Appium, JUnit, TestNG, and Cucumber.

• Selenium for web application testing

• Appium for mobile application testing

• JUnit and TestNG for unit testing

• Cucumber for behavior-driven testing

• Continuous Integration tools like Jenkins for automated testing

Smoke testing is a quick and shallow test to check if the application is stable enough for further testing. Sanity testing is a subset of regression testing to check if the bugs have been fixed and new changes have not affected the existing functionality.

• Smoke testing is done to check if the critical functionalities of the application are working fine.

• Sanity testing is done to check if the bugs have been fixed and new ...read more

SDLC, STLC, Waterfall model, smoke testing, black box testing, quality, stub and driver, levels of testing, UAT, system testing, defect, defect life cycle.

• SDLC (Software Development Life Cycle) is a process followed for software development.

• STLC (Software Testing Life Cycle) is a process followed for software testing.

• Waterfall model is a linear sequential approach to software development.

• Smoke testing is a preliminary ...read more