Associate Analytics Interview Questions and Answers

Inner join of two tables with 5 and 3 entries can result in a minimum of 0 and a maximum of 3 entries.

• Inner join returns only the matching rows from both tables.

• The maximum number of entries in the result will be equal to the number of matching rows.

• If there are no matching rows, the result will have 0 entries.

• In this case, the maximum number of entries will be 3, as there can be at most 3 matching rows.

Tuple and list are two data structures in Python with different properties.

• Tuple is immutable while list is mutable

• Tuple uses () while list uses []

• Tuple is faster than list for accessing elements

Inner join returns only the matching records from both tables, while outer join returns all records from both tables.

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

• Outer join combines rows from two tables and includes unmatched rows from one or both tables.

• Inner join is used to retrieve data that exists in both tables.

• Outer join is used to retrieve data that may or may not exist in both tables.

• Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 O...read more

Advance Excel formulas include VLOOKUP, IF, SUMIF, COUNTIF, INDEX, MATCH, CONCATENATE, LEFT, RIGHT, MID, and more.

• VLOOKUP - searches for a value in a table and returns a corresponding value in the same row

• IF - checks if a condition is true or false and returns a value based on the result

• SUMIF - adds the values in a range that meet a specified criteria

• COUNTIF - counts the number of cells in a range that meet a specified criteria

• INDEX - returns the value of a cell in a specifie...read more