Tapzo Interview Questions and Answers

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Ans. 
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: S
Answered by AI
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Q1. What is the social networking
Ans. 
Social networking refers to the use of internet-based platforms to connect with others, share information, and build relationships.
• Social networking sites allow users to create profiles, connect with friends, and share updates and photos.

• Popular social networking platforms include Facebook, Twitter, Instagram, and LinkedIn.

• Social networking can be used for personal connections, professional networking, and marketing pu...read more
Answered by AI
Add your answer
Q2. How many people added in google
Ans. 
The number of people added in Google is constantly changing due to hiring, acquisitions, and other factors.
• Google adds thousands of employees each year through hiring and acquisitions.

• As of 2021, Google has over 140,000 employees worldwide.

• The exact number of people added in Google can vary depending on the time frame and specific context of the question.
Answered by AI
Add your answer
Q3. What is the charts accountant
Ans. 
A charts accountant is a professional who specializes in creating and analyzing financial charts and graphs to help businesses make informed decisions.
• Charts accountants use data visualization techniques to present financial information in a clear and concise manner.

• They often work with software programs like Microsoft Excel or Tableau to create charts and graphs.

• Charts accountants help businesses track key performance...read more
Answered by AI
Add your answer
Q4. What is a gaming review
Ans. 
A gaming review is an evaluation of a video game, assessing its gameplay, graphics, sound, and overall quality.
• Gaming reviews provide insights into the strengths and weaknesses of a game.

• They often include ratings or scores to summarize the reviewer's opinion.

• Reviews may also discuss the game's story, mechanics, replay value, and technical performance.

• Examples of popular gaming review websites include IGN, GameSpot, an
Answered by AI
Add your answer
Q5. How many salary in google
Add your answer

Very hardworking studying in coding

2 medium leetcode questions were asked

Q1. Difference between polymorphism and inheritance
Add your answer
Q2. Dsa question related to array
Add your answer

Q1. Explain about project
Add your answer
Q2. What did you do in you internship
Add your answer

Q1. What is the SQL query used to remove duplicates from a dataset?
Ans. 
Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table

• Example: SELECT DISTINCT column1, column2 FROM table_name;

• Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates
Answered by AI
Add your answer
Q2. What is the SQL query to find the third highest salary in a table?
Ans. 
Use a subquery to find the third highest salary in a table using SQL.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the third row.

• Use a subquery to select the third highest salary from the sorted list.
Answered by AI
Add your answer

Q1. What are the different roles in Power BI?
Ans. 
Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.
• Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards

• Power BI Analyst - analyzes data using Power BI to provide insights and recommendations

• Power BI Administrator - manages security, access, and data sources in Power BI

• Power BI User - consumes reports and dashboards
Answered by AI
Add your answer
Q2. SQL - basicand advanced questions
Add your answer

It was good 20 mcqs 3 coding questions

Q1. Dsa and core subjects like cn os
Add your answer
Q2. Dsa questions and core subjects
Add your answer

Q1. Basic family discussion and salary details
Add your answer

Questions related to Python and SQL, as well as a few multiple-choice questions in data science.

Q1. Project Explanation as well query related to project
Add your answer
Q2. Machine learning basic question
Add your answer

2 Leetcode Medium questions on hackerrank

Q1. Kadane algorithm based question
Add your answer
Q2. Leetcode medium
Add your answer
Q3. Resume based questions
Add your answer

Q1. Probability question math problem
Add your answer
Q2. Puzzle to solve
Add your answer
Q3. AI based question
Add your answer
Q4. 1 question to solve Leetcode medium
Add your answer

Q1. Processes and details about steps involved when a server is accessed from browser. L1-L7
Add your answer
Q2. Troubleshoot drive errors and server HW.
Add your answer