Trenser Technology Solutions Private Limited Lead Analyst Interview Questions and Answers

There are 150 Mcqs (aptitude + tech+ reasoning) and 2 coding questions

Q1. Explain about the projects
Add your answer

Q1. Explain about yourself
Add your answer

We have given 12 puzzles on hackerearth based on probability and statistics and have to solve in 45 minutes

Q1. There is a biased dice with the probability of 1 and 2 is 25% each. Find the probability of even number.
Ans. 
The probability of rolling an even number on a biased dice with 25% chance for 1 and 2 is 50%.
• The biased dice has a 25% chance for rolling a 1 and a 25% chance for rolling a 2, totaling 50% for odd numbers.

• Since there are only two odd numbers on a dice (1 and 2), the probability of rolling an even number is 50%.

• The probability of rolling an even number on a standard dice is 50% as well, since there are 3 even numbers o
Answered by AI
Add your answer
Q2. What is the pdf and pmf?
Ans. 
PDF stands for Probability Density Function and PMF stands for Probability Mass Function.
• PDF is used for continuous random variables while PMF is used for discrete random variables.

• PDF represents the probability distribution of a continuous random variable.

• PMF represents the probability distribution of a discrete random variable.

• Example: PDF can be used to calculate the probability of a random variable falling within a...read more
Answered by AI
Add your answer

Q1. Difference Between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

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

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. SQL Execution order
Add your answer
Q3. Coalesce function in SQL
Ans. 
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
• Coalesce function takes multiple parameters and returns the first non-null value.

• It is commonly used to handle null values in SQL queries.

• Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
Answered by AI
Add your answer

APTITUDE TEST ON MATHEMATICAL QNS

Q1. SPEED AND DISTANCE
Add your answer
Q2. PROFIT N LOSS NUMBER SYSTEM
Ans. 
Profit and loss number system is a method used to calculate the financial performance of a business.
• Profit is the positive difference between revenue and expenses.

• Loss is the negative difference between revenue and expenses.

• Net profit is the total profit after deducting all expenses.

• Net loss is the total loss after deducting all expenses.

• Profit and loss statement shows the financial performance of a business over a spe
Answered by AI
Add your answer

Q1. Basic 10-15btheorotical question
Add your answer
Q2. Join + window funct question
Add your answer

Q1. Asked different variety of puzzles
Add your answer

Q1. SQL questions, puzzle
Add your answer
Q2. Cohort analysis
Add your answer
Q3. Guesstimates questions were asked
Add your answer
Q4. Project overview
Add your answer
Q5. Tableau basicquestions
Add your answer