Indium Software Manual Test Engineer Interview Questions and Answers

Q1. What are the differences between a sprint review and product grooming?
Ans. 
Sprint reviews assess completed work, while product grooming prioritizes and refines backlog items for future sprints.
• Sprint Review occurs at the end of a sprint to showcase completed work to stakeholders.

• Product Grooming (or Backlog Refinement) is an ongoing process to prioritize and clarify backlog items.

• In a Sprint Review, the team demonstrates features; for example, showing a new app feature to stakeholders.

• During ...read more
Answered by AI
Add your answer
Q2. How will you track defects?
Ans. 
Defect tracking involves documenting, managing, and resolving software defects throughout the testing process.
• Use a defect tracking tool like JIRA or Bugzilla to log defects with detailed descriptions.

• Assign severity levels (e.g., critical, major, minor) to prioritize defect resolution.

• Include steps to reproduce the defect, screenshots, and environment details for clarity.

• Regularly update the status of defects (e.g., o...read more
Answered by AI
Add your answer
Q3. What are the SQL queries used to remove duplicates from a database?
Add your answer
Q4. What is the difference between the WHERE and HAVING clauses in SQL?
Ans. 
WHERE filters rows before aggregation; HAVING filters after aggregation in SQL queries.
• WHERE clause is used to filter records before any groupings are made.

• HAVING clause is used to filter records after aggregation functions like COUNT, SUM, AVG.

• Example of WHERE: SELECT * FROM Employees WHERE Age > 30;

• Example of HAVING: SELECT Department, COUNT(*) FROM Employees GROUP BY Department HAVING COUNT(*) > 5;
Answered by AI
Add your answer
Q5. What is the difference between UNION and UNION ALL in SQL?
Ans. 
UNION combines results from two queries, removing duplicates; UNION ALL includes all results, keeping duplicates.
• UNION removes duplicate rows from the result set.

• UNION ALL includes all rows, even duplicates.

• Example of UNION: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example of UNION ALL: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

• UNION may be slower due to duplicate elimination, w
Answered by AI
Add your answer
Q6. What are the different types of joins in SQL, and can you explain each of them?
Ans. 
SQL joins combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left ...read more
Answered by AI
Add your answer
Q7. Write a quires for join the table greater than 5000k in course payment and need to fetch the course name, payment, student name, course name and age. There are 2 table one is course details and student det...read more
Add your answer

Basic arthmetic,English

Q1. Anything to ask related to coding
Add your answer

Q1. Easy to interact with HR
Add your answer

Q1. Sql questions advance
Add your answer
Q2. File processing
Add your answer
Q3. Write a sql query to join
Add your answer

Q1. What is regression testing what is explosure testing which used for tools for bug defection 2 question scenario based question
Ans. 
Regression testing is the process of retesting modified software to ensure that the existing functionalities are not affected.
• Regression testing is performed after making changes to the software to ensure that the changes do not introduce new bugs or break existing functionality.

• It helps in identifying any unintended side effects of the changes made.

• Regression testing can be done manually or using automated testing too...read more
Answered by AI
Add your answer