10+ Interview Questions and Answers

Comparing business analysis of two hypothetical companies under different scenarios

• Company A is a tech startup with high growth potential but also high risk

• Company B is a well-established retail chain with steady revenue but limited growth

• Under a booming economy, Company A is likely to outperform Company B due to its growth potential

• In a recession, Company B may fare better than Company A as consumers prioritize essential purchases

Add two numbers without using a third variable

• Use bitwise XOR operation to add the numbers without carry

• Use bitwise AND operation to calculate the carry

• Repeat the process until there is no carry left

Profit is 10

• Profit = Selling Price - Cost Price

• Profit = 30 - 20 = 10

Find missing number in array of strings

• Convert strings to integers for comparison

• Iterate through the array to find the missing number

• Consider edge cases like empty array or multiple missing numbers

Python script to calculate factorial of a number.

• Create a function that takes a number as input.

• Use a loop to multiply the number by decreasing integers until reaching 1.

• Return the final result as the factorial of the input number.

The length of an array refers to the number of elements it contains.

• Use the .length property to find the length of an array.

• Example: let arr = ['apple', 'banana', 'orange']; arr.length will return 3.

applymap is used to map a value from one table to another while join is used to combine two or more tables based on a common field.

• applymap is used for one-to-one mapping while join is used for many-to-one mapping

• applymap is faster than join for small datasets

• join can handle more complex data relationships than applymap

• applymap can be used to replace null values with a default value

• join can be used to aggregate data from multiple tables

There are two types of load in Qliksense: script load and data load.

• Script load involves loading and transforming data using the Qlik scripting language.

• Data load involves loading data from various sources into QlikSense for analysis and visualization.

• Script load is done in the script editor, while data load is done in the data manager.

• Examples of script load include loading data from a CSV file and transforming it using script functions.

• Examples of data load include connecti...read more

Joins are used to combine data from two or more tables based on a related column.

• Joins are used in SQL to retrieve data from multiple tables.

• They are used to combine rows from two or more tables based on a related column.

• There are different types of joins such as inner join, left join, right join, and full outer join.

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

• Left join returns all the rows from the left table and matching rows from the right table.

• Right join r...read more