Impact Analytics Interview Questions, Process, and Tips

Q1. Resultant rows for different SQL joins
Ans. 
Resultant rows for different SQL joins
• Inner join - returns rows that have matching values in both tables

• Left join - returns all rows from the left table and the matched rows from the right table

• Right join - returns all rows from the right table and the matched rows from the left table

• Full outer join - returns all rows when there is a match in either left or right table
Answered by AI
Add your answer
Q2. Group by and join SQL questions involving nulls
Add your answer

Coding round had one SQL and one Python question. And some mcqs around python and math

Q1. It was on store and products querying with SQL
Add your answer
Q2. Same questions were asked in Python
Add your answer

Q1. It was a techno-managerial round with some guesstimates and about my recent projects
Add your answer

There were 2 coding questions one is based on array and one more is based on abstraction

Q1. What is black box testing
Ans. 
Black box testing is a software testing method where the internal structure or code of the application is not known to the tester.
• Tester focuses on the functionality of the software without knowing its internal workings

• Tests are based on requirements and specifications

• Input data is provided and output is compared against expected results

• Examples include equivalence partitioning, boundary value analysis, and decision ta
Answered by AI
Add your answer
Q2. What is regression testing
Ans. 
Regression testing is the process of retesting a software application to ensure that new code changes have not adversely affected existing functionality.
• Regression testing is performed after code changes to verify that the existing features still work correctly.

• It helps in identifying any defects introduced by new code changes.

• Automated testing tools are often used for regression testing to save time and effort.

• Example...read more
Answered by AI
Add your answer

Q1. Advancement in HTML5 compared to HTML3

Ans. 

HTML5 introduced new features like canvas, video, audio, and improved semantics compared to HTML3.

• HTML5 introduced new elements like ,

• HTML5 improved semantics with new structural elements like

  ,

• HTML5 introduced new form input types like email, url, date, range for better user experience.

• HTML5 added support for offline web applications through the use of Application Cache.

Add your answer