LatentView Analytics Interview Questions, Process, and Tips

Questions on aptitude with some coding questions on python

Q1. Asked case based question to understand business understanding. Asked me to write some SQL queries.
Add your answer

Q1. Basic CV based HR questions
Add your answer

Q1. Basic SQL questions
Add your answer
Q2. Statistical questions
Add your answer

Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question

Easy
50% went to next round

Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
Add your answer
Q2. Difference between UNION and UNION ALL
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the results of two or more SELECT statements and removes duplicates.

• UNION ALL merges the results of two or more SELECT statements without removing duplicates.

• UNION is slower as it has to remove duplicates, while UNION ALL is faster.

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

• Example: SELECT column...read more
Answered by AI
Add your answer
Q3. Types of SQL commands
Ans. 
SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
• SELECT: retrieves data from a database

• INSERT: adds new records to a table

• UPDATE: modifies existing records in a table

• DELETE: removes records from a table

• CREATE: creates a new table, view, or index

• DROP: deletes a table or index
Answered by AI
Add your answer

Q1. Common HR questions
Add your answer

Q1. SQL problems to solve nth highest salary
Ans. 
Use SQL query with subquery to find nth highest salary
• Use ORDER BY and LIMIT to get the nth highest salary

• Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary
Answered by AI
Add your answer

Q1. GCP big query Architecture
Add your answer

Q1. SQL queries scenario based
Add your answer
Q2. Just gave schema and asked 5 questions.
Add your answer

Basic coding questins

Q1. All based on my project
Add your answer