SHAREit Technology Interview Questions and Answers

Q1. SLQ basic questions
Add your answer
Q2. SQL Joins
Add your answer

Q1. SQL qeus to find 5th max salary of an employee from employee_table.
Add your answer
Q2. Find avg salary of employees for each department & order employee within a department by age.
Add your answer
Q3. Different between SLA & OLA
Add your answer
Q4. Views AND Triggers in SQL
Add your answer

Q1. SQL Functions, Range, Rank, Dense Rank questions
Add your answer
Q2. Ticket Management
Add your answer

Q1. Managerial Round
Add your answer
Q2. Work Experience
Add your answer

Q1. Compensation Discussion
Add your answer

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
Add your answer
Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
Ans. 
The query selects all columns and calculates the total amount for each customer in table t2.
• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partiti...read more
Answered by AI
Add your answer
Q3. How many Customers has purchased same item on the Same day more than onnce
Ans. 
To find customers who purchased the same item multiple times on the same day.
• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Answered by AI
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

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

Q1. Questions related to devops tools such as azure terraform kubernetes.
Add your answer
Q2. Java concurrency and exception handling
Add your answer

Q1. Why do you want to join this organization?
Ans. 
I am impressed by the company's innovative approach to DevOps and its commitment to continuous improvement.
• I am excited about the opportunity to work with cutting-edge technologies and tools in a collaborative environment.

• I admire the company's strong reputation for fostering professional growth and development.

• I believe my skills and experience align well with the organization's goals and values.
Answered by AI
Add your answer
Q2. Expected salary
Ans. 
My expected salary is based on my experience, skills, and the market rate for Devops Engineers.
• I have researched the average salary range for Devops Engineers in this location.

• I am looking for a competitive salary that reflects my expertise and contributions.

• I am open to discussing salary based on the overall compensation package offered.
Answered by AI
Add your answer

A 90-minute coding test on HackerRank, which includes one medium, one easy, and one hard question.

Q1. What is the index of the first occurrence where a pattern string matches with a text string?
Add your answer
Q2. Given a string, how can we find the minimum length substring whose sum is greater than or equal to a specified target?
Add your answer